Count of IDs between two dates

[bmchale1983]

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

[Wlad_Masi]

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

[krishna_2644 · Accepted solution]

Check the Attached.

[bmchale1983]

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

[krishna_2644]

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

[Seier-Alsenz]

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