topic Conditional show/hide sub totals in Pivot table in QlikView

Conditional show/hide sub totals in Pivot table

Fri, 02 May 2014 10:37:08 GMT

Hi All

We've a bit tricky requirement on Display of sub totals in Pivot table.

We've a pivot table with more than 20 dimensions and 5 expressions and conditional sho/hide is enabled on them.

And our users want similar option to show/display totals on any of the columns they want, like we can do in excel on ad hoc basis.

Can you guys let me know if it is possible in QlikView.

Thanks in advance!

Surendra

its_anandrjs — Fri, 02 May 2014 10:40:02 GMT

Refer adhoc reports for this the same requirement you full fill from that use

Create a Dimension table and Metric table refer the samples in the sample folder.

Gysbert_Wassenaar — Fri, 02 May 2014 10:42:00 GMT

See attached example

Fri, 02 May 2014 10:50:59 GMT

Fantastic stuff Gysbert...

Thank you!

Wed, 03 Dec 2014 23:44:45 GMT

Hi Gysbert,

This is very clever, but how do you load twice the same dimension ?

I don't succeed and don't see any two loads for same dimension in your script.
Where is the trick?

Thanks for your reply.

regards

Guy

Gysbert_Wassenaar — Thu, 04 Dec 2014 14:31:38 GMT

Simply add a calculated dimension and then use just the dimension name as expression for the calculated dimension.

Fri, 05 Dec 2014 21:18:20 GMT

Thanks , I succeed now to add twice the same dimension and allow the hide and show of the total. Great !

Best regards;

Guy .