Remove/Filter records if measure is Zero

[#1]

Hi,

I got a table with few dimensions and KPI's.

I would want to filter the KPI/Measure if it is zero, then use it for ranking..Ranking part is bit clear..

Tried using Set analysis to exclude zero's but couldn't travel further.

Ex: Just sample data

Country State Sales Discount

USA     S1     1000     20

USA     S2     800      30

USA      S3     700     0

IND     S1     400     10

C1     S1     0          0

C2     S1     0          10

I would need records ONLY if DISCOUNT > 0

Tried Set analysis but couldn't get it.

Thanks in advance.

Regards,

qlikshare

[swuehl]

What have you tried as expression?

In a chart with dimensions Country and State, try two expressions

=sum({<Discount = {">0"} >} Sales)

=sum({<Discount = {">0"} >} Discount)

assuming that you don't have negative Discount records that balance to zero on dimension level.

[santhoo_san]

Hi,

see if this helps

[maxgro]

in a chart with 1 expression, Sales

try with a calculated dimension

=if(Discount>0,Discount)

and check "Suppress when value is null"