topic Re: Static dimension in Pivot table in QlikView

Static dimension in Pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the data as per excel sheet (static_Dimension.xlsx).

In script I have written the following

Temp:

LOAD [Product],

City,

//if([Date], Null(),[Business]) as ,

[Business],

Count,

[Date]

FROM

[..\static_Dimension.xlsx]

(ooxml, embedded labels, table is Sheet1);

I have created the Pivot as below

When I select the date (from the list box) following is displayed.

But the requirement is that all the dimensions("Global", "Local", "Mumbai 1", "Mumbai 2") should always displayed irrespective of date selected (or any other filters)

OR atleast "Mumbai 1", "Mumbai 2" should always displayed irrespective of date selected (or any other filters)

Re: Static dimension in Pivot table

Anil_Babu_Samineni — Mon, 01 Oct 2018 04:18:04 GMT

You can call your dimension which you want to restrict selection in set analysis. How is your measure looks?

Re: Static dimension in Pivot table

shiveshsingh — Mon, 01 Oct 2018 05:16:20 GMT

Please check attached,

Re: Static dimension in Pivot table

Anonymous — Mon, 01 Oct 2018 07:53:51 GMT

Thanks for reply. Can you please tell me what exactly changes are done

Re: Static dimension in Pivot table

shiveshsingh — Mon, 01 Oct 2018 08:02:33 GMT

For business Dimension, tick mark Show All values check box

and in presentation tab, uncheck suppress Zero values.

Thanks

Shivesh