topic Count of IDs between two dates in App Development

Count of IDs between two dates

bmchale1983 — Thu, 25 Apr 2019 19:55:50 GMT

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.

	Start	End	Dec-18	Jan-19	Feb-19	Mar-19	Apr-19
1	1/1/2019	4/1/2019		1	1	1	1
2	3/1/2019	4/1/2019				1	1
3	7/1/2018	4/25/2019	1	1	1	1	1
4	8/1/2018	12/1/2018	1
5	12/1/2018	3/1/2019	1	1	1	1
6	1/1/2019	4/1/2019		1	1	1	1
7	2/1/2019	3/1/2019			1	1
8	3/1/2019	4/1/2019				1	1
9	8/1/2018	4/1/2019	1	1	1	1	1
10	9/1/2018	1/1/2019	1	1
			5	6	6	8	6

Re: Count of IDs between two dates

Wlad_Masi — Thu, 25 Apr 2019 20:50:02 GMT

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).

Re: Count of IDs between two dates

Qrishna — Thu, 25 Apr 2019 23:12:34 GMT

Check the Attached.

Re: Count of IDs between two dates

bmchale1983 — Fri, 26 Apr 2019 19:47:47 GMT

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

Re: Count of IDs between two dates

Qrishna — Fri, 26 Apr 2019 20:04:36 GMT

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

Re: Count of IDs between two dates

Seier-Alsenz — Tue, 05 Apr 2022 06:07:36 GMT

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