Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Count

Hi everybody,

Maybe someone can help me please ?

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

PatientIn DateOut DateBilled Date
101.01.201905.01.201913.01.2019
201.01.201904.01.201916.01.2019
302.01.201908.01.201917.01.2019
403.01.201906.01.2019Null
503.01.201907.01.201913.01.2019

 

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

DateCount
06.01.20193
07.01.20194
08.01.20195
09.01.20195
10.01.20195
11.01.20195
12.01.20195
13.01.20193
14.01.20193
15.01.20193
16.01.20192

 

i dont find the way to calculate this !

Thanks in advanced for your help

Chris

4 Replies
Highlighted
Valued Contributor II

Re: Count

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

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

Highlighted
New Contributor III

Re: Count

Nofonciona.PNG

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

Contributor

Re: Count

Hi,

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

Re: Count

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)