topic Re: scrip table for rolling in QlikView

scrip table for rolling

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: scrip table for rolling

Anonymous — Thu, 28 Sep 2017 04:13:51 GMT

awaiting suggestions

Re: scrip table for rolling

techvarun — Thu, 28 Sep 2017 04:20:48 GMT

what is the expected ooutput?

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

Re: scrip table for rolling

Anonymous — Thu, 28 Sep 2017 04:26:19 GMT

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))

Re: scrip table for rolling

rahulpawarb — Thu, 28 Sep 2017 04:31:45 GMT

Please refer below:

Calculating rolling n-period totals, averages or other aggregations

Re: scrip table for rolling

Anonymous — Thu, 28 Sep 2017 04:36:10 GMT

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

Re: scrip table for rolling

Anil_Babu_Samineni — Thu, 28 Sep 2017 04:45:26 GMT

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

Re: scrip table for rolling

Anonymous — Thu, 28 Sep 2017 05:30:10 GMT

Hi- thanks for the info

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

can suggest for anyof the thread

Re: scrip table for rolling

avinashelite — Thu, 28 Sep 2017 05:32:29 GMT

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

Re: scrip table for rolling

Anonymous — Thu, 28 Sep 2017 05:42:18 GMT

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

Re: scrip table for rolling

Anonymous — Thu, 28 Sep 2017 12:10:54 GMT

any help

Re: scrip table for rolling

Anonymous — Thu, 28 Sep 2017 14:01:21 GMT

hello any suggestions are appreciated

Re: scrip table for rolling

ravikumar_iyana — Thu, 28 Sep 2017 14:38:32 GMT

Hi,

You are tried Rangesum:

rangesum([Sales Volume],peek('Rolling')) as Rolling

Re: scrip table for rolling

Anonymous — Thu, 28 Sep 2017 14:39:56 GMT

yes treid but no acurate results i am getting

Re: scrip table for rolling

ravikumar_iyana — Thu, 28 Sep 2017 14:44:20 GMT

I cant be able to open u r Qvw u can keep ScreenShot

Re: scrip table for rolling

Anonymous — Thu, 28 Sep 2017 14:53:37 GMT

sharing screenshots is not an apt at the moment appologies

Re: scrip table for rolling

Anonymous — Thu, 28 Sep 2017 15:53:53 GMT

any suggestions