Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT 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