topic Re: Restrict Expansion in Pivot Table in QlikView

Restrict Expansion in Pivot Table

Sun, 17 Aug 2014 01:13:58 GMT

I have a Pivot table with two Dimensions and with the expression of PTD figures for the Financial Year for the P &L.

My First Dimension is used valueList() as I needed to group them in unique order as well as grouping.Second Dimension is Database field and calculate the expression using Set Analysis.

I want to Restrict the Expansions for Grey lines as per my attached Excel Sheet Table2. Otherwise it duplicate the second Dimensions again as Table 1 in the sheet.I tried to use 'Enable Conditional Option' but it didn't work for me.

I also tried to use valuelist() for my second Dimensions and worked perfectly but it is really slow...

Can you please advice.

Thank you.

Harsh

Re: Restrict Expansion in Pivot Table

ecolomer — Sun, 17 Aug 2014 03:46:45 GMT

You can introduce an column with the level as you can see in the file

Re: Restrict Expansion in Pivot Table

Sun, 17 Aug 2014 13:05:34 GMT

Hi Enrique

How this is going to work? This data is coming from SQL table and stored in qvd. Can you expain bit more the way your idea is working?

Thanks

Harsh

Re: Restrict Expansion in Pivot Table

ecolomer — Sun, 17 Aug 2014 14:09:12 GMT

Yes, with conditional view

Re: Restrict Expansion in Pivot Table

Mon, 18 Aug 2014 02:03:24 GMT

Hi Enrique

I have tried it and didn't work for me. Can you send me the sample if possible ?

Regards

Harsh

Re: Restrict Expansion in Pivot Table

Tue, 19 Aug 2014 01:12:46 GMT

Hi Enrique

I have finally used with Excel template and did work for me.

Thanks for your help

Regards

Harsh