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]

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]

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

[marcus_sommer]

What happens by: columnno(TOTAL) ?

- Marcus

[frederic-x]

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

[frederic-x]

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]

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]

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