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: 
jisephcirspy
Contributor III
Contributor III

Count every entry before date plus date itself?

I want to create a chart showing a timeline (dimension = date) and the y-axis should be the count method.

display2.png

 

 

 

Here the entry 2020-05-05 should count 1, the entry 2020-06-08 should count 3, the entry 2020-06-16 should count 6.

How can I do this?

1 Solution

Accepted Solutions
MayilVahanan

Hi @jisephcirspy 

Try like this

Dim: Date

Exp: Rangesum(Above(Count(YourMethodFieldName),0, RowNo()))

Thanks & Regards,
Mayil Vahanan R

View solution in original post

3 Replies
MayilVahanan

Hi @jisephcirspy 

Try like this

Dim: Date

Exp: Rangesum(Above(Count(YourMethodFieldName),0, RowNo()))

Thanks & Regards,
Mayil Vahanan R

View solution in original post

jisephcirspy
Contributor III
Contributor III
Author

you are a genius mayil ❤️

jisephcirspy
Contributor III
Contributor III
Author

but the filter function isn't working properly now... it only show one entry when I filter every single date. Do you know how to fix that?