topic Re: Count every entry before date plus date itself? in QlikView https://community.qlik.com/t5/QlikView/Count-every-entry-before-date-plus-date-itself/m-p/1764672#M718390 <P>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?</P> Thu, 26 Nov 2020 11:15:11 GMT jisephcirspy 2020-11-26T11:15:11Z Count every entry before date plus date itself? https://community.qlik.com/t5/QlikView/Count-every-entry-before-date-plus-date-itself/m-p/1764644#M718387 <P>I want to create a chart showing a timeline (dimension = date) and the y-axis should be the count method.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="display2.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/44869iE675154941343125/image-size/large?v=v2&amp;px=999" role="button" title="display2.png" alt="display2.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>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.</P><P>How can I do this?</P> Fri, 15 Nov 2024 23:33:29 GMT https://community.qlik.com/t5/QlikView/Count-every-entry-before-date-plus-date-itself/m-p/1764644#M718387 jisephcirspy 2024-11-15T23:33:29Z Re: Count every entry before date plus date itself? https://community.qlik.com/t5/QlikView/Count-every-entry-before-date-plus-date-itself/m-p/1764667#M718388 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/121194">@jisephcirspy</a>&nbsp;</P><P>Try like this</P><P>Dim: Date</P><P>Exp: Rangesum(Above(Count(YourMethodFieldName),0, RowNo()))</P> Thu, 26 Nov 2020 11:01:19 GMT https://community.qlik.com/t5/QlikView/Count-every-entry-before-date-plus-date-itself/m-p/1764667#M718388 MayilVahanan 2020-11-26T11:01:19Z Re: Count every entry before date plus date itself? https://community.qlik.com/t5/QlikView/Count-every-entry-before-date-plus-date-itself/m-p/1764671#M718389 <P>you are a genius mayil <span class="lia-unicode-emoji" title=":red_heart:">❤️</span></P> Thu, 26 Nov 2020 11:06:30 GMT https://community.qlik.com/t5/QlikView/Count-every-entry-before-date-plus-date-itself/m-p/1764671#M718389 jisephcirspy 2020-11-26T11:06:30Z Re: Count every entry before date plus date itself? https://community.qlik.com/t5/QlikView/Count-every-entry-before-date-plus-date-itself/m-p/1764672#M718390 <P>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?</P> Thu, 26 Nov 2020 11:15:11 GMT https://community.qlik.com/t5/QlikView/Count-every-entry-before-date-plus-date-itself/m-p/1764672#M718390 jisephcirspy 2020-11-26T11:15:11Z