Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
qliktick
Partner
Partner

Cumulation covid-19 daily cases

there are new cases of covid-19 reported by the ecdc Department. i Need to sum up the (new) daily cases to get the total number in a line-chart / table per day.

the "cumulate" box within the Chart is not working, all my effords with set-expressions didn't work. i thought i am an advanced user, but after Hours for such a Basic feature i am frustrated (table calc in Tableau ist easy)

please help and use my source..

 

Labels (1)
2 Solutions

Accepted Solutions
Frank_Hartmann
Master II
Master II

try  this expression:

Rangesum(above(sum (Cases),0,RowNo()))

 

View solution in original post

sergio0592
Specialist III
Specialist III

Hi,

If you the cumulative daily cases, try with the Following formula as expression. It should works

rangesum(Above(Sum(Cases),0,RowNo()))

View solution in original post

2 Replies
Frank_Hartmann
Master II
Master II

try  this expression:

Rangesum(above(sum (Cases),0,RowNo()))

 

View solution in original post

sergio0592
Specialist III
Specialist III

Hi,

If you the cumulative daily cases, try with the Following formula as expression. It should works

rangesum(Above(Sum(Cases),0,RowNo()))

View solution in original post