Discussion board where members can get started with Qlik Sense.
How can I use a pie chart to show me the bottom 5 sub classes by excluding 0 and negative values.
Dimension is Subclass
Measure is sales
I used Rangemax(Sales,0) - not working
I used If(Sum([Sales]) > 0, Sum([Sales])) - not working
Any other advice? I am new to qliksense and all the help will be appreciated.
May be this
Try checking sum by the same grouping as the chart:
If(Sum(Aggr(Sum([Sales]),[Sub Class]))>0, Sum([Sales]))
If(Sum(Aggr(Sum([Fct Scl Binc Sale Sell Amt]]),[SubClass]))>0, Sum([Fct Scl Binc Sale Sell Amt]))
yields below error - undefined values.
What I would like is all the sub classes that are negative and have zero values, that they be excluded from calculating the bottom 5 subclasses.
The error still remains as the chart cannot be displayed due to negative and zero values
instead you can do in dimension
limitation --exact value-- >0
This works perfectly but I have already set my limitation to display only bottom 5.
I can't have 2 limitations
use calucalted dimension for 5
for negtive use option
Expression: FirstSortedValue(SubClass, Aggr(Sum([Fct Scl Binc Sale Sell Amt]),SubClass),5)
Returns and error of undefined values