Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i'd like to build a cumulated sum in a pivot table under Qlik Sense
Script :
load * inline [Date,Site,Value,
'01/01/2018','Paris',10
'02/01/2018','Paris',20
'04/01/2018','Paris',50
'01/01/2018','Nice',100
'03/01/2018','Nice',77];
in the Pivot table , i use Site and Date as dimension and the usual expression for cuulated sum :
=Rangesum(before(sum(Value),0,Month(Date)))
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
Frédéric
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.
- Marcus
danke sehr anyway !
Frédéric
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)))