This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I want to transfer a formula from a Dashboard to the loadingscript. The Data itself is stuctured as followed:
Right now I use the following formula in a Diagram:
and get the total aggregated amount for each Day, Day1 60, Day2 180, Day3 280 and thats perfect.
to transfer it to the script without loosing information, my first step was to add the column "terminated Amount" with the formula:
if(terminated (boolean)=1,Amount) as [terminated Amount]
using this script now:
sum([terminated (boolean)]) as [terminated (boolean)],
sum([terminated Amount]) as [terminated Amount]
order by Day
group by Day;
brings me to the following table:
Now I want to add the aggregated amounts like I made it with Rangesum(), somehow it doesnt work in the Script.
The Table I want in the end looks like this:
Can someone please help me with it? I'm sure its just a tiny error in my script, but it's consuming a lot of time now...
sum([terminated Amount]) as [terminated Amount],
Rangesum( sum([terminated Amount]), Peek(aggrTerminatedAmount)) as aggrTerminatedAmount
View solution in original post
Thank you Stefan!