Variable

[smilingjohn]

Hi All,

I am using the below expression to get the cumulative in my pivot table .
and there one more expression similar to this.

Is there a way to get this expression written into the script and get a column in the front end ?

rangeSum(Before(TOTAL Count({<Year*={'>2010'},Department={Cosmatics','IT','Finance','Sales'}>}ID)+ Sum(0),0, ColumnNo(TOTAL)))

Can someone please explain me on this

Thanks in advance

[Brett_Bleess]

Hey John, yeah, you just need to figure out what table you want that in and then add this to that part of the load scrip:

rangeSum(Before(TOTAL Count({<Year*={'>2010'},Department={Cosmatics','IT','Finance','Sales'}>}ID)+ Sum(0),0, ColumnNo(TOTAL))) as fieldname

If that is not what you meant, please provide some further detail on things, that may precipitate some others chiming in at that point too.

I just realized you may want that in a variable, syntax there would be:

LET variablename = rangeSum(Before(TOTAL Count({<Year*={'>2010'},Department={Cosmatics','IT','Finance','Sales'}>}ID)+ Sum(0),0, ColumnNo(TOTAL)))

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Regards,
Brett