topic Re: Totals in Pivot tables in QlikView

Totals in Pivot tables

Sun, 11 Nov 2012 09:49:44 GMT

Hi Guys,

I have a pivot table as in the example below.

I need to allow users to select "showing total" by diferent expressions, or no totals at all.

For example, Getting Totals by "Parent CC" or getting totals by "LE / Cost Center", or no total at all.

Is there any nice work around without using macro?

Thanks in advance,

Aldo.

Gysbert_Wassenaar — Sun, 11 Nov 2012 11:03:42 GMT

In QV11 it's fairly easily done with two variables and conditional expressions for the two dimensions. See attached example.

Mon, 12 Nov 2012 06:13:32 GMT

Nice & Easy,

(It would be nice having the posibility to do it witha condition instead of duplicating...).

Thanks 🙂

Aldo.