
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
- « Previous Replies
-
- 1
- 2
- Next Replies »


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ???????


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What happens by: columnno(TOTAL) ?
- Marcus

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Columnno() function is also not giving the same result in qlikview and qliksense

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
no improvement with columnno(TOTAL)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I meant the whole datamodel not one table or do you just a testing with complete empty application unless the table and chart?
- Marcus

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- « Previous Replies
-
- 1
- 2
- Next Replies »