Count

[QlikTonic]

Hi everybody,

Maybe someone can help me please ?

I have 5 patients with check-in date, check-out date and billed date

Patient	In Date	Out Date	Billed Date
1	01.01.2019	05.01.2019	13.01.2019
2	01.01.2019	04.01.2019	16.01.2019
3	02.01.2019	08.01.2019	17.01.2019
4	03.01.2019	06.01.2019	Null
5	03.01.2019	07.01.2019	13.01.2019

I need to count, by day, the number of patient left from the establishment and not billed yet

Date	Count
06.01.2019	3
07.01.2019	4
08.01.2019	5
09.01.2019	5
10.01.2019	5
11.01.2019	5
12.01.2019	5
13.01.2019	3
14.01.2019	3
15.01.2019	3
16.01.2019	2

i dont find the way to calculate this !

Thanks in advanced for your help

Chris

[dwforest]

Count({<[Billed Date]-={*}>} Patient)

This will aggregate automatically if put in a table with [In Date]

[QlikTonic]

Thanks but i did not succeed to have a good result 😞

[santhiqlik]

Hi,

Try this...
Count({<[Billed Date]={"=Len([Billed Date])>0"}>}Patient)

[bing_jville]

A set analysis on Count(Patient):
Condition 1: Out Date is not null
Condition 2: Billed Date is null

Count({<[Out Date]-={"''"}, [Billed Date]={"''"}>}Patient)