topic Re: horizontal percentage in pivot table in QlikView

horizontal percentage in pivot table

brijesh1991 — Wed, 04 Nov 2015 11:57:00 GMT

Hi,

As per the attachment, I wanted to have horizontal %.

Example: for only Row A: >1%= >1/(>1+>2+>3)

In our case >1%= 5/(5+4+6)=5/15=1/3=33.33%

If I do: Sum(value)/ Sum(Total Value)--- then it's giving me vertical total as denominator of % formula.

Can you please help me with set analysis,

Kushal_Chawda — Wed, 04 Nov 2015 12:01:40 GMT

Please share the sample application

brijesh1991 — Wed, 04 Nov 2015 12:22:43 GMT

Please find the demo app.