Exclude negative values in pie chart - qliksense

[gisellevaleta]

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

[sunny_talwar]

May be this

RangeMax(Sum(Sales), 0)

[dwforest]

Try checking sum by the same grouping as the chart:

If(Sum(Aggr(Sum([Sales]),[Sub Class]))>0, Sum([Sales]))

[gisellevaleta]

Hi David

Using expression

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.

[gisellevaleta]

Hi Sunny

The error still remains as the chart cannot be displayed due to negative and zero values

[Chanty4u]

instead you can do in dimension

limitation --exact value-- >0

[gisellevaleta]

Hi Chanty

This works perfectly but I have already set my limitation to display only bottom 5.

I can't have 2 limitations

[Chanty4u]

use calucalted dimension for 5

for negtive use option

FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),5)

[gisellevaleta]

Hi Chanty

Expression:  FirstSortedValue(SubClass, Aggr(Sum([Fct Scl Binc Sale Sell Amt]),SubClass),5)

Returns and error of undefined values

[Chanty4u]

try this

=aggr(if(rank(sum(Value))

  <=5) ,Dim),Dim)