Get Percentage per Month

[bsbernabe]

Hello There,

Someone can guide how to apply this kind of format to Qlikview. See below some detailed.

 

To get the percentage : This is the formula that i use 

(NOV|1TO30| 8,375,171.73 ) /  (OCT|REGULAR| 34,011,506.45 )  = NOV        24.62% 

Output:

NOV        24.62%    43.03%    48.48%    75.57%    4.28%
DEC        22.82%    46.29%    17.87%    120.39%    7.52%

Best Regards,

Bing