Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
george456
Creator
Creator

Running Accumulative Share Pivot Table

Dear Community

 

I need to calculate a running Percentage accumulative in a pivot table.

My Syntax is as :

rangeSum(Before(sum(if(Year2Date(MonthYr,0,if(Month(vMaxMonth)>11,1,Month(vMaxMonth)+1),vMaxMonth),$(vMeasure)))/
sum(TOTAL if(Year2Date(MonthYr,0,if(Month(vMaxMonth)>11,1,Month(vMaxMonth)+1),vMaxMonth),$(vMeasure))),0,ColumnNo()))

I am getting no output

Can you suggest a solution

 

Thanks

George

0 Replies