topic Re: How to remove null dimension from pivot table in QlikView

How to remove null dimension from pivot table

Anonymous — Wed, 05 Aug 2015 09:47:37 GMT

All the header are dimensions ,I wanted to show all values including zero value. But when show all is checked it adding one extra dimension at the bottom of table and I want to remove it.

Re: How to remove null dimension from pivot table

settu_periasamy — Thu, 06 Aug 2015 04:50:45 GMT

Hi,

Did you checked, Suppress When value is null in dimension Tab?

Re: How to remove null dimension from pivot table

Anonymous — Thu, 06 Aug 2015 05:01:52 GMT

No, Because if I check suppress when value is null in dimension tab then remaining all zero values (above the bottom row)will disappear and I want to display that.

Re: How to remove null dimension from pivot table

settu_periasamy — Thu, 06 Aug 2015 05:23:13 GMT

for clarification, do you have the value for the dimension(Region_Hierarchy_SName, Model, Model year) which is showing value zero?

And, checking purpose, convert your pivot table to straight table, again check, still the null value displayed or not?

is it possible to post the sample app?

Re: How to remove null dimension from pivot table

Anonymous — Thu, 06 Aug 2015 05:40:58 GMT

yes I have values for all the dimensions and it will display according to my date selection .in above picture I have only selected April month so its showing me value for April and rest all are zero.

one more thing that month names which coming on header is also one dimension with name NewDim.

below I am sharing my dimension tab screen shot.