Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
gabroteddy
Contributor III
Contributor III
‎2020-02-26 06:03 AM

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.

Preview file
26 KB
prova.qvw
670 Views
0 Likes
1 Reply
Brett_Bleess
Former Employee
Former Employee
‎2020-03-31 01:56 PM

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.
617 Views
0 Likes