https://community.qlik.com/t5/QlikView/How-to-count-occurrences/m-p/1679396#M506343 <P>Hi,</P><P>I have to prepare a dashboard that counts me some information.<BR />In particular:</P><OL><LI>How many patients (PAZIENTE) have been on therapy in the last 3 months (FA_DATA_EROG = last 3 month)</LI><LI>how many patients have started a therapy distinct per year (year in FA_DATA_EROG) and per therapy (AP_MINSAN10)</LI><LI>how many patients have changed a therapy&nbsp;&nbsp;(same PAZIENTE but different AP_MINSAN10)</LI></OL><P>Can somone explain me how i can do it in specific dasboard?</P><P>I attach the excel with some data in example and a .qvw file where i started working.</P> Wed, 26 Feb 2020 11:03:10 GMT gabroteddy 2020-02-26T11:03:10Z https://community.qlik.com/t5/QlikView/How-to-count-occurrences/m-p/1679396#M506343 <P>Hi,</P><P>I have to prepare a dashboard that counts me some information.<BR />In particular:</P><OL><LI>How many patients (PAZIENTE) have been on therapy in the last 3 months (FA_DATA_EROG = last 3 month)</LI><LI>how many patients have started a therapy distinct per year (year in FA_DATA_EROG) and per therapy (AP_MINSAN10)</LI><LI>how many patients have changed a therapy&nbsp;&nbsp;(same PAZIENTE but different AP_MINSAN10)</LI></OL><P>Can somone explain me how i can do it in specific dasboard?</P><P>I attach the excel with some data in example and a .qvw file where i started working.</P> Wed, 26 Feb 2020 11:03:10 GMT https://community.qlik.com/t5/QlikView/How-to-count-occurrences/m-p/1679396#M506343 gabroteddy 2020-02-26T11:03:10Z https://community.qlik.com/t5/QlikView/How-to-count-occurrences/m-p/1689587#M506344 <P>See duplicate post:&nbsp;<A href="https://community.qlik.com/t5/New-to-QlikView/how-to-make-dashboard-with-specific-counters/m-p/1679358#M386876" target="_blank">https://community.qlik.com/t5/New-to-QlikView/how-to-make-dashboard-with-specific-counters/m-p/1679358#M386876</A></P><P>Regards,<BR />Brett</P> Tue, 31 Mar 2020 17:56:46 GMT https://community.qlik.com/t5/QlikView/How-to-count-occurrences/m-p/1689587#M506344 Brett_Bleess 2020-03-31T17:56:46Z