Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikss,
I have 3 fileds : quarteryear value1 value2
2018-Q1 10 50
2018-Q2 20 40 ...... Etc.....
i have calculated rangesum in char
t by using expression : aggr(rangesum(above(sum(value1),0,rowno()),quarteryear)
which worked fine, but i want to calculate that in script. someone suggest me.
Attached excel file and screenshot .