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.
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.
Expression: FirstSortedValue(SubClass, Aggr(Sum([Fct Scl Binc Sale Sell Amt]),SubClass),5)
Returns and error of undefined values