Qlikview Pivot Table

[#1]

Hi,

I need to know how to view and hide certain sub-dimensions based on main dimension in a pivot table. Please refer the attachment for further clarification. Really appreciate if anyone could help me on this issue.

Rgds,

Hansika

[Gysbert_Wassenaar]

If those sub-dimensions are really subdimensions and not expressions then you need to change your data model and make sure a sub-dimension has only the values you want for the main dimension. If those sub-dimensions are expressions you need to create the sub-dimension values in the script and use one expression that checks if the value of the sub-dimension is 'Cost' or 'Days' and calculates the correct result based on that value: if(MySubDimension = 'Cost', sum(Cost), if(MySubDimension = 'Days', sum(Days))

[SreeniJD]

Hi

QV has rich set of actions, you can hide or show any dimension based on the triggers. can you please send me sample data, worth to create a POC.

HTH

Sreeni

[miguelbraga]

Hi Hansika

Can you please send a sample so that we can provide you a solution?

Many thanks,

Miguel.

[#5]

HI Sreeni,

Thanks for the reply. I have attached a sample for your reference

rgds,

Hansika

[#6]

HI Miguel,

Thanks for the reply. I have attached a sample for your reference

rgds,

Hansika

[Gysbert_Wassenaar · Accepted solution]

See attached qvw for a possible solution.

[#8]

Hi,

Thanks. I understood the solution provided by you. But, though i have included costs and days to a single table in the provided sample, in reality I'm maintaining two separate tables for costs and days figures. I cannot join them due to some limitations and the complexity of the source files. Hence i cannot create a single column as 'Measure' for both the tables. Could you please let me know whether there is any other workaround for this issue. Thanks for the help

Rgds,

Hansika

[#9]

Hi, Please disregard the previous comment. I was able to get the required result from the solution that you provided. Thanks