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 count occurrences

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.

1 Reply
Brett_Bleess
Former Employee
Former Employee

See duplicate post: https://community.qlik.com/t5/New-to-QlikView/how-to-make-dashboard-with-specific-counters/m-p/16793...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.