% of participation from 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:

I want to generate the following results.

For the following table, I selected Year=2015 and Month=5.

If I select Year = 2015 and Month = 6, the expected result table must be:

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]

Hi,

I hope it will help u to complete u r task

In the expressions :

for getting the Accumulation: rangesum(above(total sum(paid), 0, rowno(Total)))

                     associated %:(rangesum(above(total sum(paid), 0, rowno(Total)))/sum(TOTAL paid))*100

Thanks and Regards,

Balaji.k

[tresesco]

Could you share your sample qvw?

[#4]

Below expressions should give you an idea. For the given requirement these are working. But work on to improve them to generalize. For example, if multiple months are selected, these expressions may not work. Then you need to find out the maximum month from the selected. Do that for yourself. And these will work only when one Year and one Month are selected. Change the expressions as per your requirement. Let us know if you need any help for that.

Accumulated Payed - Sum({<Month={'<=$(#=GetFieldSelections(Month))'}>}Payed)

Accumulated Payed % - Sum({<Month={'<=$(#=GetFieldSelections(Month))'}>} Payed)/Sum({<Month={'<=$(#=GetFieldSelections(Month))'}>} TOTAL<Channel> Payed)

Regards,

KKR

[#5]

Of course.

[#6]

Unfortunately, it did not work the suggested solution.

I attach the qlikview application where your suggestion is used.

Thanks a lot for your help,

--- maoh

[#7]

Thanks for your answer. But it did not work because the expected result is not obtained.

I attach two qlikview application where the suggestions of tresesco and Kranthikumar M are used.

[Anonymous · Accepted solution]

Hi,

Check the attachment.

[#9]

Thanks a lot! It works very fine!