Sum of number between 2 dates

[porteralon]

I have a Table with 2 time columns, one with start time and one with end time and a column of number of people. 

I want to be able to show on a line chart or heatmap the amount of people for each hour.

I tried to use for the dimension one of the columns (start time or end time) and it only show me the amount of people for each hour and not the sum of the people for each hour.

[jochem_zw]

?? if you have for example this data:

Start	End	#Persons
10:15	11:20	10
10:16	10:59	20
10:30	10:45	30
11:15	12:02	40

you could create for example a bar chart with Start as dimension and sum(#Persons) as measure.

GL

[porteralon]

I want the chart to caculate the amount of people in the restaurant for each leriod of time.

for example -in your table it supose to show 

10:15-10:16 - 10

10:16-10:30 -30

10:30-10:45 - 60

10:45-10:59 - 30

10:59-11:15 - 10

11:15-11:20 - 50

11:20-12:02 - 40

hpe you under stand me now, 

Thanks for the hrlp ! 

Alon 

[jochem_zw]

ah ok, i think my table is not what you have, but the intervalmatch function on for example the startdate should do what you want: https://help.qlik.com/en-US/sense/February2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

You can create your own interval and see if the starttime is in this interval. The interval you can use as a dimension on the chart.

[porteralon]

I read about the IntervalMatch, and I didnt found how I can implement it in my problem. 

I will explain my problem better. 

I have this table, and my excepted output is a line chart where the dimension is the time in the day, and in the measures I will have the sum of guests according to the numbers and hour in this table.

For Exmple in in 21:27:00 it will show 15, and in 21:27:21 - 5, and in 21:27:31 - 0 

Hope you understood me well, 

Alon

[jochem_zw]

Hi Alon,

can you please share this table in Excel format as an attachment.

And can you please draw what you would like to see in the chart/table?

[porteralon]

Attaching the excel table.

[jochem_zw]

Still don't exactly know what you would like to see, but i think you have to play with the intervalmatch function.

See my example based on your data