Qlik Community

App Development

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

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bmchale1983
Contributor III
Contributor III

Count of IDs between two dates

I have the blow data to the left and looking to make an expression to achieve the values on the right.  Not sure if I need to use a range sum, or what field I would need to use for a dimension to accomplish.  

 StartEnd  Dec-18Jan-19Feb-19Mar-19Apr-19
11/1/20194/1/2019   1111
23/1/20194/1/2019     11
37/1/20184/25/2019  11111
48/1/201812/1/2018  1    
512/1/20183/1/2019  1111 
61/1/20194/1/2019   1111
72/1/20193/1/2019    11 
83/1/20194/1/2019     11
98/1/20184/1/2019  11111
109/1/20181/1/2019  11   
     56686

 

Capture.PNG

1 Solution

Accepted Solutions
krishna_2644
Specialist III
Specialist III

 

Check the Attached.

1.PNG

View solution in original post

5 Replies
Wlad_Masi
Employee
Employee

Is there a reason why your data ir in this format ?
If possible I would advise you to use the table in a different format. EX:

Start, End, Flag
1/1/2019,4/1/2019, Jan-2019
1/1/2019,4/1/2019, Feb-2019
1/1/2019,4/1/2019, Mar-2019
1/1/2019,4/1/2019, Apr-2019
3/1/2019, 4/1/2019, Mar-2019
3/1/2019, 4/1/2019, Apr-2019

With a table structure is like this, you can use as a dimension in your bar chart the Flag field, and as measure count(Start).
To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
krishna_2644
Specialist III
Specialist III

 

Check the Attached.

1.PNG

bmchale1983
Contributor III
Contributor III
Author

This is correct, is there a thread for creating a date range qvw?  Or can you share sample script you used?

krishna_2644
Specialist III
Specialist III

Hi - you can check script from the attached qvw in the abve post.

Seier-Alsenz
Contributor II
Contributor II

Hi,

is that possible to post the solution as anconverted file (*.qvf) that i can use in Qlik Sense? i'm unable to convert QWF-File at our QMC. i would be pleased so much.

Kind regards