topic Re: How to remove dimension who had null values? in QlikView

How to remove dimension who had null values?

Wed, 25 Nov 2020 16:16:04 GMT

hi Experts,

I am trying to show 80 20 report for my customers.For that i have done one chart had customers as dimension and using expression as

if( (Rangesum(above(count(bookings),1,rowno())) / count(total<bookings>bookings)) <=0.8,

count(bookings) ).

This gives values as 20% customers who are all giving 80% business. but my problem is the chart shows null values to other customers who are all not in the 20% customer.

can anyone give solution how remove this null values?

please see the image attached.

thanks in advance

Re: How to remove dimension who had null values?

sunny_talwar — Fri, 22 Apr 2016 09:23:05 GMT

Try checking 'Suppress When Null' on the presentation tab of the chart properties

Re: How to remove dimension who had null values?

Fri, 22 Apr 2016 09:28:46 GMT

thanks for your reply,

i have tried but it won't work.

Re: How to remove dimension who had null values?

Anonymous — Fri, 22 Apr 2016 09:34:22 GMT

Instead you can use Dimension Limits to show 20% or 80% customers. Thanks

Re: How to remove dimension who had null values?

sunny_talwar — Fri, 22 Apr 2016 09:38:55 GMT

Would you be able to share a sample?

Re: How to remove dimension who had null values?

Fri, 22 Apr 2016 10:33:36 GMT

thanks satayadev it works.