Create a monthly bar chart using master calendar

[wanyunyang]

Hi all,

I have a data set like below:

Customer, Start Date, End Date

A, Jan 1, Mar 15

B, Jan 1, Feb 10

C, Feb 2, Mar 2

Now I need to draw a monthly bar chart to show how many customers are with us each month (in this example, Jan 2, Feb 3, Mar 2). In the script, I have a master calendar (Date, Month, Year). Can I use the master calendar and the data set to draw such a bar chart?

Thanks in advance!

[kaushiknsolanki]

You would need to create an intermediate table using Interval match.

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefix....