Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Could you share your sample qvw?
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
Of course.
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
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.
Hi,
Check the attachment.
Thanks a lot! It works very fine!