Q-Tip #1 – Beware of DISTINCT!

We all know and use QlikView keyword DISTINCT, which makes the resulting table of the load unique. What we don’t usually know, until we learn it the hard way, is that DISTINCT can be very dangerous and deceiving. We will mention two major issues with DISTINCT that are not too obvious: DISTINCT doesn’t always mean…

Read More

Intro into Q-Tips

Q-Tips are little nuggets of knowledge that we collect on the way as we learn more about anything — QlikView, BI, systems, life… In this section, we’ll be publishing little tips and tricks, “gotcha” and “aha!” moments, warnings and bug reports. What’s in the name? Well, besides our obvious obsession with the letter “Q”, we…

Read More