Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Exclude negative values in pie chart - qliksense

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

13 Replies
MVP

May be this

RangeMax(Sum(Sales), 0)

Specialist II

Try checking sum by the same grouping as the chart:

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

Contributor III
Author

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.

Contributor III
Author

Hi Sunny

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

MVP

instead you can do in dimension

limitation --exact value-- >0

Contributor III
Author

Hi Chanty

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

I can't have 2 limitations

MVP

use calucalted dimension for 5

for negtive use option

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

Contributor III
Author

Hi Chanty

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

Returns and error of undefined values

MVP

try this

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

<=5) ,Dim),Dim)