Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
andreina
New Contributor

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

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!

2 Replies

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

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

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)