Rangesum in Pivot table

[frederic-x]

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

[marcus_sommer]

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

[frederic-x]

danke sehr anyway !

Frédéric

[fadibouchnak]

Hello Fred
Try a condition to replace Null with '0' :
If(IsNull(Field),0,Field)

[SMassa]

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)))