If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
i'd like to build a cumulated sum in a pivot table under Qlik Sense
load * inline [Date,Site,Value,
in the Pivot table , i use Site and Date as dimension and the usual expression for cuulated sum :
this is what i obtain in Qlikview
this is what i obtain in QlikSense
the problem is : Sense does not compute the cumulated value when there is no data for the given month and the site
how can i make it in Sense (as in Qlikview)?
Many thanks in advance
Then I'm running out of ideas. I'm not sure but if Sense and/or this table has settings how they handle NULL's it might be worth to play with them.
danke sehr anyway !
Did you ever figure out a fix for this issue?
I have the same problem and am getting "-" when there is no applicable check date in particular year and quarter.
This is my measure:
rangesum( before( sum([Loss Amount]), 0, NoOfColumns(total)))