topic Re: Qlikview Pivot Table in QlikView

Qlikview Pivot Table

Mon, 28 Sep 2015 06:28:54 GMT

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

Re: Qlikview Pivot Table

Gysbert_Wassenaar — Mon, 28 Sep 2015 09:44:21 GMT

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))

Re: Qlikview Pivot Table

SreeniJD — Mon, 28 Sep 2015 09:45:41 GMT

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

Re: Qlikview Pivot Table

miguelbraga — Mon, 28 Sep 2015 09:46:16 GMT

Hi Hansika

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

Many thanks,

Miguel.

Re: Qlikview Pivot Table

Tue, 29 Sep 2015 04:38:45 GMT

HI Sreeni,

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

rgds,

Hansika

Re: Qlikview Pivot Table

Tue, 29 Sep 2015 04:41:24 GMT

HI Miguel,

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

rgds,

Hansika

Re: Qlikview Pivot Table

Gysbert_Wassenaar — Tue, 29 Sep 2015 13:31:21 GMT

See attached qvw for a possible solution.

Re: Qlikview Pivot Table

Wed, 30 Sep 2015 05:38:37 GMT

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

Re: Qlikview Pivot Table

Wed, 30 Sep 2015 06:01:57 GMT

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