topic Re: Re: Restricting Zero Values in Chart in QlikView

Restricting Zero Values in Chart

Fri, 06 Dec 2013 09:03:10 GMT

Hello Gurus,

I need help into the below issue I am facing.

I have a chart wherein dimension - Customer is limited to Smallest 5. But chart is showing "No data to display" and found this is because there are 5 Customers with a zero value. If I uncheck "Suppress Zero Values" , it shows 5 Customers with Zero Values.

But I want to display lowest 5 customers with a non - zero value. How could this be acheived.

Thanks in Advance,

Sree

Re: Restricting Zero Values in Chart

Fri, 06 Dec 2013 09:07:55 GMT

Can you post a sample app?

Re: Restricting Zero Values in Chart

MK_QSL — Fri, 06 Dec 2013 09:17:36 GMT

Dimensions

[Customer Name]

Expression

IF(SUM(Sales) > 0, SUM(Sales))

Sort

Y value ascending

Restrict by dimension limit to lowest 5.....

Re: Restricting Zero Values in Chart

MK_QSL — Fri, 06 Dec 2013 09:20:45 GMT

Another way is

Dimension

if(Aggr(Rank(IF(SUM(Sales) > 0, -SUM(Sales))),[Customer Name])<=5, [Customer Name])

Expression

SUM(Sales)

No need to restrict data...

Re: Re: Restricting Zero Values in Chart

Fri, 06 Dec 2013 14:37:39 GMT

Hi Manish,

Thank you so much......that solved my problem !!

Below I have attached my solution in case someone else hits into this discussion with the same problem

Kindest Regards,

Sree

Re: Restricting Zero Values in Chart

MK_QSL — Fri, 06 Dec 2013 14:40:58 GMT

Glad that my reply help you.