topic Keep zero-values by a dimension but let the user to filter by it in QlikView

Keep zero-values by a dimension but let the user to filter by it

Anonymous — Thu, 22 Dec 2016 13:52:44 GMT

Hello,

I need to keep the zero- value in my pivot table ( and for that I uncheck the option "Suppress zero-values" ) but if I wanted to filter by any of the dimension included in the pivot table, it keeps the table as it is (with all the possible values of the dimension) but just updates the information related to the value selected.

Is there any way to keep zero values but if the user select a single value of the dimension, it refresh the table and just shows the value value selected?

Thank you!

Re: Keep zero-values by a dimension but let the user to filter by it

sunny_talwar — Thu, 22 Dec 2016 13:55:23 GMT

Can you share a sample qvw with the expected output?

Re: Keep zero-values by a dimension but let the user to filter by it

avinashelite — Thu, 22 Dec 2016 14:10:37 GMT

To make it simple ...I think you should make use of 2 Pivot tables

1.With Suppress zero-values checked

2.With Suppress zero-values un-checked

based on the user selection hide the show the required pivot table , you could use the condition in layout like

GetSelectedCount(Dimension_required)