How to Select In Expression

[#1]

Hi,

Having a straight table with Customer dimension and sum(LineSalesAmount) expression for example.

I wish select only the data where the sum(LineSalesAmount) is >= vVariable

It should be something easy to do but for the life of me cannot work out how Qlikview want me to achive it!!

Any pointers would be great,

Thanks in advance.

Alex.

[#2 · Accepted solution]

Hi Alex,

In the expressions, use If(sum(LineSalesAmount)>=vVariable,sum(LineSalesAmount))

Hope it helps

Thanks
Sabal

[alexandros17]

In the expression (it must be the only expression) write:

If(sum(LineSalesAmount) is >= $(myVar), sum(LineSalesAmount), 0)

and in the presentation tab check the box "suppress zero values"

[mrybalko]

It is better to use set analysis expression:

sum({<Customer={'=sum(LineSalesAmount)>$(vInputSum)'}>} LineSalesAmount)