topic Formula in Qlikview in QlikView

Formula in Qlikview

Fri, 13 May 2011 09:11:18 GMT

I am trying to display a table but only select distinct rows from one of the columns (an IN formula) but am struggling, can you help?

Re: Formula in Qlikview

johnw — Fri, 13 May 2011 21:47:43 GMT

So, for instance you want the sum of sales for customers, but ONLY for customers Bob, Carla and Dan? You could do this:

dimension = if(match(Customer,'Bob','Carla','Dan'),Customer)
expression = sum(Sales)

Or this:

dimension = Customer
expression = sum({<Customer={'Bob','Carla','Dan'}>} Sales)

I suspect the second approach would be faster to execute.

Formula in Qlikview

Mon, 16 May 2011 07:57:36 GMT

Thanks for the help John!

Formula in Qlikview

Mon, 16 May 2011 08:17:51 GMT

Sorry - I must sound like a fool here!

I have 3 fields ' Current Year' 'Previous Year' and Description.

I want to show a table with only 3 values from the description field and the other 2 fields associated - I have tried your suggestion but it doesnt seem to work.

Andy

Formula in Qlikview

johnw — Mon, 16 May 2011 17:27:26 GMT

I'm sorry, but I don't really follow. Can you show some example data, and then what you want the chart itself to look like?

Formula in Qlikview

Wed, 18 May 2011 12:25:02 GMT

I answered my own question John, thanks for the help!