topic Pivot Table Help in QlikView

Pivot Table Help

satishkurra — Mon, 08 May 2017 17:36:46 GMT

I have below problem.

Business wants to display this report of total on row wise.

I'm getting 100 % on column wise.

Is there any way

Dimensions: Type and Week Starting Date

Measure: Sum(Hours)

Please help if we can achieve this in QV

Re: Pivot Table Help

krishnacbe — Mon, 08 May 2017 17:54:49 GMT

Hi,

Hope you are using Show Partial sum for Week Starting Date. Uncheck it and enable the Show Partial Sum check box for type. you will get the expected output.

Re: Pivot Table Help

sergio0592 — Mon, 08 May 2017 18:01:21 GMT

Create pivot chart and as expression:

=num(sum(Hours)/Sum(TOTAL <Week Starting Date> Hours) ,'#,#0%')