topic Re: Count in App Development

Count

QlikTonic — Thu, 07 Mar 2019 19:35:15 GMT

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

Re: Count

dwforest — Thu, 07 Mar 2019 20:09:21 GMT

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

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

Re: Count

QlikTonic — Thu, 07 Mar 2019 20:24:35 GMT

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

Re: Count

santhiqlik — Fri, 08 Mar 2019 11:47:08 GMT

Hi,

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

Re: Count

bing_jville — Mon, 11 Mar 2019 03:27:55 GMT

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)