Hello everyone and welcome to QlikFreak. Since this is our last entry of the year and many of you are enjoying your holidays away from the office, I thought it would be cool to try something a little different. Today, instead of having a tutorial or a fun Qlik app, I created a Qlik trivia with interesting scripting scenarios that will make you think twice before writing down your answers!
I know you don’t want me to spoil all the surprises, so we’ll check the answers at the end of the post. So anyways, without further ado, let the games begin! OK, no, wait, before you go, there’s one more thing… I think you’ll get the same results regardless of the version you’re using, but just in case, I’m working with QlikView 12 SR4 and Qlik Sense 3.1 SR4 😛
If you’re an experienced Qlik Developer, chances are that you’ve used DISTINCT in more than one of your scripts, right? Well then, tell me how many records will this table have:
a) 4 records b) 3 records c) 0 records d) OMG, he’s using Qlik Sense
Tip: The last two records are exactly the same. Continue reading