Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
gisellevaleta
Contributor III
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
sunny_talwar

May be this

RangeMax(Sum(Sales), 0)

dwforest
Specialist II
Specialist II

Try checking sum by the same grouping as the chart:

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

gisellevaleta
Contributor III
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.

gisellevaleta
Contributor III
Contributor III
Author

Hi Sunny

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

Chanty4u
MVP
MVP

instead you can do in dimension

limitation --exact value-- >0

gisellevaleta
Contributor III
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

Chanty4u
MVP
MVP

use calucalted dimension for 5

for negtive use option

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

gisellevaleta
Contributor III
Contributor III
Author

Hi Chanty

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

Returns and error of undefined values

Chanty4u
MVP
MVP

try this

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

  <=5) ,Dim),Dim)