Formula in Qlikview

[#1]

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?

[johnw · Accepted solution]

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.

[#3]

Thanks for the help John!

[#4]

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

[johnw]

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?

[#6]

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