Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
frederic-x
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

Maybe Month(Date) returned NULL in Sense through some changes within the datamodel. Therefore try it in this way:

=Rangesum(before(sum(Value),0,columnno()))

- Marcus

frederic-x
Contributor II
Author

thanks Marcus,

but it does not work (same results)

what is weird also  is the result of the Columnno() function in the pivot table

isn't it a bug of Qliksense ???????

QS Clolumno().PNG

marcus_sommer

What happens by: columnno(TOTAL) ?

- Marcus

frederic-x
Contributor II
Author

QVColumnno().PNG

Columnno() function is also not giving the same result in qlikview and qliksense

frederic-x
Contributor II
Author

no improvement with columnno(TOTAL)

marcus_sommer

I don't know if there are any differences in the chart-creation (unless the layout) between View and Sense or if it might be a bug. Beside this are both datamodels exactly the same?

- Marcus

frederic-x
Contributor II
Author

same load inline

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];

thenafter what Qlik is doing in both case is a mistery!

marcus_sommer

I meant the whole datamodel not one table or do you just a testing with complete empty application unless the table and chart?

- Marcus

frederic-x
Contributor II
Author

yes, the application is only containing the script mentionned above

it is an example in fact  (not to bother people with too heavy data structure) that I would reuse in my real application