topic Re: rangesum in script in QlikView

tst exp

Anonymous — Wed, 27 Sep 2017 02:19:27 GMT

can anyone help me on this

Re: rangesum in script

Anonymous — Wed, 27 Sep 2017 02:57:30 GMT

Any suggestions please

Re: rangesum in script

vkish16161 — Wed, 27 Sep 2017 03:11:33 GMT

Rangesum

(

Above (

Sum(Sales),0, rowno ()

)

Re: rangesum in script

Anonymous — Wed, 27 Sep 2017 03:14:31 GMT

Hi Vishnu
thanks for the response
I tried with this earlier- can u please include this in our workbook please -
yeilding no results

Re: rangesum in script

shraddha_g — Wed, 27 Sep 2017 03:14:37 GMT

Create a flag for rolling months in Master calendar n then use it in set analysis in front end

Refer Rolling Month

Rolling 12 months flag in master calendar script? | Qlik Community

Re: rangesum in script

Anonymous — Wed, 27 Sep 2017 03:27:05 GMT

Thanks for the help
I dont want to use any expression in front end as part of requirement
i want to use this as a field in script.

Re: rangesum in script

shraddha_g — Wed, 27 Sep 2017 03:31:37 GMT

Then for this requirement,

Refer Accumulation in Script

RangeSum in Script

Re: rangesum in script

Anonymous — Wed, 27 Sep 2017 03:44:35 GMT

glad for sharing and worthy
however i am unsure how to fit those in my req as not producing the desired results as exp[ected

Re: rangesum in script

shraddha_g — Wed, 27 Sep 2017 04:10:06 GMT

Share you script , sample data n expected output

Re: rangesum in script

Anonymous — Wed, 27 Sep 2017 05:43:13 GMT

any kind suggestoins?

Re: rangesum in script

Anil_Babu_Samineni — Wed, 27 Sep 2017 05:50:48 GMT

May be this?

If(ID = Previous(ID), RangeSum(IDCount, Peek('Acc_12months')), IDCount) as Acc_12months;

Re: rangesum in script

Anonymous — Wed, 27 Sep 2017 05:54:10 GMT

sorry wrong

Re: rangesum in script

Anil_Babu_Samineni — Wed, 27 Sep 2017 06:09:55 GMT

Not sure, Why it is wrong. PFA

Table:

LOAD RowNo() as RowNo,

[Pr Num],

Id,

Date,

Responsibilty

FROM

rolldata.xls

(biff, embedded labels, table is Sheet1$);

FinalTable:

LOAD *,

If(Responsibilty = Previous(Responsibilty), RangeSum(Id, Peek('Acc_12months')), Id) as Acc_12months

Resident Table Where Responsibilty like 'ABC'

Order By Responsibilty;

DROP Table Table;

Re: tst exp

Anonymous — Wed, 27 Sep 2017 06:30:57 GMT

thanks- but the values we get are not the expected values

Re: tst exp

Anil_Babu_Samineni — Wed, 27 Sep 2017 06:33:37 GMT

Okay

Re: tst exp

Anonymous — Thu, 28 Sep 2017 03:40:01 GMT

can we do any expressions that gets the required output?
i did tried all the ways possibly - afraid i may left out with empty hands to find expression

any suggesions

Re: tst exp

Anil_Babu_Samineni — Thu, 28 Sep 2017 04:21:06 GMT

I am assuming instead of script, Accumulation is good practice in UI.

Here we go

Rangesum(Below(Sum({<Responsibilty = {"ABC"}>} Id),0),Above(Id,1,RowNo(TOTAL)))

Re: tst exp

Anonymous — Thu, 28 Sep 2017 05:29:19 GMT

thanks

we need it in script only as per our needs

Re: tst exp

Anil_Babu_Samineni — Thu, 28 Sep 2017 05:53:02 GMT

From this thread, It's already stated either from Back end and Front end. I am not sure about is there any third work left of these two (Script / UI)

Re: tst exp

Anonymous — Thu, 28 Sep 2017 05:58:00 GMT

Hi
backend expressions we used but the values are not accuraate as i mentioned earlier- that is what i requestef for anyother expression which yeilds accurate results

with the current expression we r getting sum of the values not the individual values -