scrip table for rolling

[Anonymous]

Hi,

I was been struggling for couple of days on the script side rolling data months - but couldnot hit the target.

could some one pls suggest script to get the values of rolling 12 months- i need a script feild which is having 12 months data not to use any UI expressions.

please suggest me

[Anonymous]

awaiting suggestions

[techvarun]

what is the expected ooutput?

Rolling value (Sum or count?) based on what? (Pr num? ID? responsibility?) Please explain

[Anonymous]

I shared you the qvw- with a chart in it- chart has expression which gives rolling 12 months data
but same we have to do form script side - instead of UI expression

the below expression or similar expression i want to use in script :

RANGESUM(ABOVE(SUM({<respons = {'ABC'}>}IDCount),0,12))  

[rahulpawarb]

Please refer below:

Calculating rolling n-period totals, averages or other aggregations

[Anonymous]

Hi Rahul,
thanks for sharing but my requirment is diff- i dont want to use any expression in UI
everythig i should get it from script side

[Anil_Babu_Samineni]

I've seen one question from 4 threads, So, Sara removes him and notify the high priority. Make sure, Don't create duplicate https://community.qlik.com/message/1352485

[Anonymous]

Hi- thanks for the info

however its because i felt may reach to new people - so , created though

can suggest for anyof the thread

[avinashelite]

You mean you don't what to use a flag condition also in the set analysis ???

[Anonymous]

Hi Avinash
thanks for your response- nope from set analysis
all should have do from scripting side sadlly  that's wehre the complexity lies