Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Re: how to make dashboard with specific counters

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

Highlighted
Contributor III
Contributor III

Re: how to make dashboard with specific counters

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.

Highlighted
Specialist III
Specialist III

Re: how to make dashboard with specific counters

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
Highlighted
Specialist III
Specialist III

Re: how to make dashboard with specific counters

commQV88.PNG