Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gisellevaleta
New 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

Re: Exclude negative values in pie chart - qliksense

May be this

RangeMax(Sum(Sales), 0)

dwforest
Valued Contributor

Re: Exclude negative values in pie chart - qliksense

Try checking sum by the same grouping as the chart:

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

gisellevaleta
New Contributor III

Re: Exclude negative values in pie chart - qliksense

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

Re: Exclude negative values in pie chart - qliksense

Hi Sunny

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

sureshqv
Esteemed Contributor III

Re: Exclude negative values in pie chart - qliksense

instead you can do in dimension

limitation --exact value-- >0

gisellevaleta
New Contributor III

Re: Exclude negative values in pie chart - qliksense

Hi Chanty

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

I can't have 2 limitations

sureshqv
Esteemed Contributor III

Re: Exclude negative values in pie chart - qliksense

use calucalted dimension for 5

for negtive use option

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

gisellevaleta
New Contributor III

Re: Exclude negative values in pie chart - qliksense

Hi Chanty

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

Returns and error of undefined values

sureshqv
Esteemed Contributor III

Re: Exclude negative values in pie chart - qliksense

try this

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

  <=5) ,Dim),Dim)

Community Browser