topic How to show all values except Null() in a dimension in Pivot in QlikView

How to show all values except Null() in a dimension in Pivot

Thu, 28 Jan 2016 03:47:45 GMT

Hi Everyone,

I have a scenario where I have to show all the values in a field as a dimension in Pivot Table except NULL value.

I am using above 'Show All Values' option which is helping in showing all values but with NULL as well as below:

The moment I try to alter the dimension to ignore NULL value, it disables the above 'Show All Values' option which again suppresses the 0 values.

Would appreciate suggestions for the issue.

Thanks

PradeepReddy — Thu, 28 Jan 2016 09:49:52 GMT

select the 'Suppress when Value is Null' option in dimension

Thu, 28 Jan 2016 09:55:44 GMT

Fri, 29 Jan 2016 03:09:12 GMT

Hi Pradeep,

Thanks for your reply, I tried this option too, but its giving me below result:

However it should come like below:

Regards,

Neelam

PradeepReddy — Fri, 29 Jan 2016 12:54:42 GMT

see the attachment.. it might be helpful for you...

If still not resolved your issue, Please provide sample QVW..