topic Re: Pivot table with Overall total not dependent on dimension values in QlikView

Pivot table with Overall total not dependent on dimension values

Manish — Wed, 04 Mar 2020 13:20:51 GMT

Hi Guys

Is it possible to make below mentioned pivot table where i can have a company total at the end along with dimension total

Mandate	Managed	Non Managed	Total
State
A	10	5	15
B	20	6	26
C	30	7	37
Total	60	18	78
Company Total	100	20	120

Re: Pivot table with Overall total not dependent on dimension values

Anil_Babu_Samineni — Wed, 04 Mar 2020 13:23:07 GMT

Yes, Please supply the data set to work or explain where did you fail?

Re: Pivot table with Overall total not dependent on dimension values

Manish — Wed, 04 Mar 2020 13:30:03 GMT

I used valuelist like valuelist('',Company Total), and used pick and match to write expression but i couldn't strict the dimension "State " like i am able to do for expressions

Re: Pivot table with Overall total not dependent on dimension values

Brett_Bleess — Thu, 02 Apr 2020 11:38:52 GMT

Per Anil's comment, really going to need the QVW in order to have a look at things for you to see what may be going wrong. If you have data you are worried about, you can use Settings\Document Properties\Scrambling tab to scramble any fields you wish to mask things.

Regards,
Brett