Problem to get the % of participation for the accumulated data?


#1

Hi!

I try to get a qlikview pivot table the % of participation from accumulated data. but I cannot get the expected results. Can someone help me? I appreciate very much your help.

I have the following data:

Year   Month   Channel   Customer    Payer
2015     5        11      AAA         100
2015     5        11      BBB         200
2015     5        21      CCC         300
2015     6        11      AAA         200
2015     6        11      EEE         400
2015     6        21      CCC         600

I want to generate the following results:

Channel    Customer    Payed      %    Accumulation       %
11          AAA         100     33.33%          100     33.33%
            BBB         200     66.67%          200     66.67%
            EEE           0      0.00%            0      0.00%
            Total       300    100.00%          300    100.00%
21          CCC         300    100.00%          300    100.00%
            Total       300    100.00%          300    100.00%

For the first result table, Month = 5 and Year = 2015

Channel    Customer    Payed      %    Accumulation       %
11          AAA         200     33.33%          300     33.33%
            BBB           0      0.00%          200     22.22%
            EEE         400      0.00%          400     44.44%
            Total       600    100.00%          900    100.00%
21          CCC         600    100.00%          900    100.00%
            Total       600    100.00%          900    100.00%

For the above result table, I select Month = 6 and Year = 2015

I know the formulas for column Payed and for the first %. But, for the columns Accumulation and the associated %, I have tried with several formulas and I cannot get the expected result.

Thanks a lot for your help!

Cordially,

— maoh


#2

Which tool are you using? Also, what are you doing? If you can provide screenshot / codes, it will be handy to give meaningful suggestions.

Kunal


#3

Hi!

I am using QlikView.

I attached the application file.

Acumulation.zip (142.3 KB)

Thanks a lot!