Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In QlikSense load script, how do i do cumulative sum for several dimensions?
Given the following input data (regarding planned changes in capacity)
StaffChanges:
Load * inline [
Period, Department, Change, Text
202401, Dept1, 100, Baseline
202402, Dept2, 100, Baseline
202401, Dept3, 100, Baseline
202403, Dept1, 10, Staff change
202404, Dept2, -15, Staff change
202404, Dept3, 25, Staff change
202407, Dept3, -10, Staff change
202401, Dept2, 50, Staff change
];
How do I create a new table, showing the current staff in each department, by month?
I want to do this in load script to ensure the data is fixed.
Hi there,
try this:
And the results are:
My only remark is that the oldest month for each department should contain the "Baseline", which is not the case for Dept2.
Hi there,
try this:
And the results are:
My only remark is that the oldest month for each department should contain the "Baseline", which is not the case for Dept2.
Ahhh... thank you.
Yes this seems to be exactly what I was looking for, but just couldn't wrap my head around at the moment.
Sorry for poor data quality in my dummy data. I was just making a few rows quckly and didn't capture everything.
Glad it worked 🙂
Cheers