topic Re: Restrict Dimension in QlikView

Restrict Dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a requirement that pivot table is displaying the data for a Month (Week wise).. I have a week filter too. When I select the week filter (say week1 ) the pivot table displays only the week 1 data as i attached but I want all the week to be displayed and when i select week 1 , Week 1 value should be displayed and remaining (Week 2,3,4) should display Zero..

Re: Restrict Dimension

jonathandienst — Thu, 09 Feb 2017 06:14:53 GMT

Possibly (depending on your data model, dimensions and expressions) just disable the Suppress Zero Values option.

Re: Restrict Dimension

avinashelite — Thu, 09 Feb 2017 06:19:20 GMT

In the dimesnion tab >Check show all values and in presentation tab un-check the suppress null ..how this should help you

Re: Restrict Dimension

Anonymous — Thu, 09 Feb 2017 06:28:12 GMT

Hi Vivek,

Please check the below screenshot and try the following steps.

1. enable 'show all values' in dimensions tab.

2. uncheck the 'Suppress zero value ' in presentation tab.

Re: Restrict Dimension

Thu, 09 Feb 2017 06:55:36 GMT

It is possible but it wont give away a good look to your pivot table, better show all the week values.