Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks
Hi Chanty
If you look on the right hand side you will see I set up my limitation and right at the bottom you will see the calculation expression =aggr(if(rank(sum([Fct Scl Binc Sale Sell Amt])
<=5) ,Dim),Dim)
which still yields the error of undefined values
Would you be able to share a sample to look at this issue?
can you add that columns into table and see what exctly values are?
Hi Chanty
Columns attached below. So basically I want the pie chart to just read the positive numbers and exclude the negative and null values. Then with those positive numbers I want to set my limitation to the bottom 5.