Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
andreina
Contributor
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
sunny_talwar

Can you share a sample qvw with the expected output?

avinashelite

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)