Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
azmeister3000
Contributor
Contributor

Cumulative Sum Across Date Output Expression Not Working

Hi  - I've got a chart where I've used the modifier to show the cumulative total by month of the set analysis. I need to do some further calculations on that number by month but the output expression doesn't work. Does anyone know how I can replicate what the chart/modifier is doing? qliksensechart.PNG

 

The end result I'm looking for is to be able to divide the 2nd column by the 3rd

Thanks

 

Labels (4)
2 Solutions

Accepted Solutions
GaryGiles
Specialist
Specialist

You can use the rangesum function to get similar results as using Modifier->Accumulation.  Something like:

rangesum(above(total Count(distinct {<[Interaction]={'Contact Created'}>} Email), 0, rowno(Total))) / 

Count(distinct {<[Interaction]={'click'}>+<[Interaction]={'visited'}>} Email)

View solution in original post

GaryGiles
Specialist
Specialist

Sorry, I missed the closing '}' on the set analysis in the first expression.  Try this:

 

rangesum(above(total Count(distinct {<[Interaction]={'Contact Created'}>} Email), 0, rowno(Total))) /

Count(distinct {<[Interaction]={'click'}>+<[Interaction]={'visited'}>} Email)

View solution in original post

4 Replies
GaryGiles
Specialist
Specialist

You can use the rangesum function to get similar results as using Modifier->Accumulation.  Something like:

rangesum(above(total Count(distinct {<[Interaction]={'Contact Created'}>} Email), 0, rowno(Total))) / 

Count(distinct {<[Interaction]={'click'}>+<[Interaction]={'visited'}>} Email)

View solution in original post

azmeister3000
Contributor
Contributor
Author

hmmm getting a missing ( error

GaryGiles
Specialist
Specialist

Sorry, I missed the closing '}' on the set analysis in the first expression.  Try this:

 

rangesum(above(total Count(distinct {<[Interaction]={'Contact Created'}>} Email), 0, rowno(Total))) /

Count(distinct {<[Interaction]={'click'}>+<[Interaction]={'visited'}>} Email)

View solution in original post

azmeister3000
Contributor
Contributor
Author

Not sure why I was - working good!