Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need cumulative counts in a bar graph (between two dates in Bar Graph)

I 'm counting cases from  open date to  close date and i have to show  distinct count  of cases  as expression and dimension as Month year.

i have to show all cases which are active between open date to close date

How to show Distinct(count of cases)  cummulative between these date in bar graph across month Year (eg nov 2013)

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Please post an example document. It's not clear if open date and close date are fields in your data model or if they are variables. It's not clear if you only have a month year field or also a date field. So it's not possible to give you a solution. It depends on the data available in your document.


talk is cheap, supply exceeds demand
Not applicable
Author

Open date and close date are in Same fact table ,they are not variable. I will post you more info ASAP can u please help with avilaible  info as if now.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

That sounds like you need to create reference dates for the cases. See this blog post: Creating Reference Dates for Intervals.


talk is cheap, supply exceeds demand