Saturday 12 May 2012

In Statements in Qlikview - Match()

I don't know about everyone else but I have often googled for how to do an in statement in Qlikview.


#Note by an In statement I am referring to how to test one value against multiple values or a range of values


As searching for the word "in" in relation to Qlikvew is nigh on impossible here's a quick post explaining how to do it and how to use it for custom sort lists:



Tuesday 8 May 2012

10 Reasons you should try out Qlikview


“Qlikview is great, all hail our wondrous shiny BI tool…” is the shout of Qlikview resellers everywhere, in this post I’m going to tell you why I think you should give it a try.

Qlikview isn’t perfect by any means, but here are some of the reasons that we first trialled it and then signed up.

Sunday 6 May 2012

A Quick Post - Exporting Current Selections with your data

I just came across this article and will be looking into it more in the future, as I have been asked multiple times on export if we can include the current selections.


I have a macro work around but it's quite clunky, this looks much more elegant


QlikTip #1: Transferring Current Selections to Excel-Export (translated)

Friday 4 May 2012

Cooking with Qlikview Variables

So it's six days since my first post and here we are at 350 views!


I was originally planning to cover something more basic in this post but I had an idea earlier on this week that I thought would be a cool demo and after trying things out I think I have it.


This post is called "Cooking with Qlikview Variables", I will be using variables input on screen in order to generate data that is then used within the Qlikview document itself...