Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikTonic
Contributor III
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
dwforest
Specialist II
Specialist II

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

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

QlikTonic
Contributor III
Contributor III
Author

Nofonciona.PNG

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

santhiqlik
Creator
Creator

Hi,

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

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)