topic Re: How to develop this report in pivot table in QlikView

How to develop this report in pivot table

its_anandrjs — Wed, 18 Mar 2020 02:55:31 GMT

How to develop Cumulative percentage calculation.

its_anandrjs — Wed, 18 Mar 2020 11:52:53 GMT

Anyone has an idea for this report

sunny_talwar — Wed, 18 Mar 2020 14:06:28 GMT

What is your expression you use? Do you have a sample we can look at?

its_anandrjs — Wed, 18 Mar 2020 15:39:32 GMT

Hi Sunny,

Attached is the data you can use that one

Dimension1:- Dealer

Dimension2:- Month

Expression:-Sum(Value)

sunny_talwar — Wed, 18 Mar 2020 15:46:30 GMT

So, you are looking to have an additional column with %?

its_anandrjs — Wed, 18 Mar 2020 16:14:50 GMT

Yes right expression is

Expression :- Sum(Total Value) / Sum(Value)

Brett_Bleess — Wed, 08 Apr 2020 21:15:38 GMT

Best I have is the following Design Blog post, not sure if I am missing something or not, hopefully it may help:

Regards,
Brett

Saravanan_Desingh — Sun, 07 Jun 2020 02:31:50 GMT

Dimension: Dealer

Expression (%):

RangeSum(Above(Total Sum(Value),0,RowNo())) / Sum(Total Value)

Saravanan_Desingh — Sun, 07 Jun 2020 02:33:18 GMT