Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
see if this helps
in a chart with 1 expression, Sales
try with a calculated dimension
=if(Discount>0,Discount)
and check "Suppress when value is null"