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: 
gabroteddy
Contributor III
Contributor III

how to make dashboard with specific counters

Hi,

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

  1. How many patients (PAZIENTE) have been on therapy in the last 3 months (FA_DATA_EROG = last 3 month)
  2. how many patients have started a therapy distinct per year (year in FA_DATA_EROG) and per therapy (AP_MINSAN10)
  3. 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.

4 Replies
dplr-rn
Partner - Master III
Partner - Master III

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

gabroteddy
Contributor III
Contributor III
Author

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.

Saravanan_Desingh

1) 

=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
Saravanan_Desingh

commQV88.PNG