topic How to Select In Expression in QlikView

How to Select In Expression

Thu, 31 Jul 2014 14:00:40 GMT

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.

Thu, 31 Jul 2014 14:07:21 GMT

Hi Alex,

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

Hope it helps

Thanks
Sabal

alexandros17 — Thu, 31 Jul 2014 14:07:26 GMT

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 — Thu, 31 Jul 2014 14:50:06 GMT

It is better to use set analysis expression:

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