Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
frederic-x
Contributor II
Contributor II

Rangesum in Pivot table

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

QV.PNG

this is what i obtain in QlikSenseQS.PNG

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

13 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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
Contributor II
Contributor II
Author

danke sehr anyway !

Frédéric

fadibouchnak
Contributor
Contributor

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

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