topic Re: how to make dashboard with specific counters in QlikView

how to make dashboard with specific counters

gabroteddy — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have to prepare a dashboard that counts me some information.
In particular:

How many patients (PAZIENTE) have been on therapy in the last 3 months (FA_DATA_EROG = last 3 month)
how many patients have started a therapy distinct per year (year in FA_DATA_EROG) and per therapy (AP_MINSAN10)
how many patients have changed a therapy (same PAZIENTE but different AP_MINSAN10)

Can somone explain me how i can do it in specific dasboard?

I attach the excel with some data in example and a .qvw file where i started working.

Re: how to make dashboard with specific counters

dplr-rn — Wed, 26 Feb 2020 16:46:12 GMT

see attached charts/text objects for 1 and 3.

for #2 you need to create a master calendar object add year and therapy as dimension and count(distinct patients) as measure

Re: how to make dashboard with specific counters

gabroteddy — Thu, 27 Feb 2020 09:31:54 GMT

Thank you.

regarding the 3rd question I need more detail:

the expression

if(count(distinct AP_MINSAN10)>1,count(distinct AP_MINSAN10))

does not correctly calculate the changes of therpy as it does not take into account the date of disbursement (FA_DATA_EROG).

I apologize if I have not explained well before but what I have to intercept (and calculate) is the change of drugs distributed (AP_MINSAN10) between two delivery dates (FA_DATA_EROG).

Can you give me the correct expression?

Thank you.

Re: how to make dashboard with specific counters

Saravanan_Desingh — Mon, 01 Jun 2020 02:29:22 GMT

=Count({<PAZIENTE={"=FA_DATA_EROG>=Today()-90"}>}DISTINCT PAZIENTE)

2) Dimensions: =Year(FA_DATA_EROG), AP_MINSAN10

Expression: Count(DISTINCT PAZIENTE)

3) Dimension: PAZIENTE

Expression: Count(DISTINCT AP_MINSAN10)>1

Re: how to make dashboard with specific counters

Saravanan_Desingh — Mon, 01 Jun 2020 02:30:39 GMT