topic HOW CALCULATE CHANGE BETWEEN TWO DATES in QlikView

topic HOW CALCULATE CHANGE BETWEEN TWO DATES in QlikView https://community.qlik.com/t5/QlikView/HOW-CALCULATE-CHANGE-BETWEEN-TWO-DATES/m-p/1681265#M506632 <P>Hi at all,</P><P>i want count how many times a patient change therapy.</P><P>I have a table like this (i attach the excel file):</P><TABLE width="811"><TBODY><TR><TD width="82">NUMMOV</TD><TD width="185">PATIENT</TD><TD width="280">DESCR</TD><TD width="141">DATA_DEL</TD><TD width="123">PHARMA_CODE</TD></TR><TR><TD width="82">67489</TD><TD width="185">PROVA PAZIENTE1</TD><TD width="280">ZELITREX*21 CPR RIV. 1000 MG</TD><TD width="141">19/12/2017</TD><TD width="123">029503024</TD></TR><TR><TD width="82">67490</TD><TD width="185">PROVA PAZIENTE2</TD><TD width="280">KIVEXA*600+300MG 30 CPR</TD><TD width="141">18/12/2018</TD><TD width="123">036644019</TD></TR><TR><TD width="82">67491</TD><TD width="185">PROVA PAZIENTE2</TD><TD width="280">ISENTRESS*400MG 60CPR</TD><TD width="141">18/12/2018</TD><TD width="123">038312017</TD></TR><TR><TD width="82">67492</TD><TD width="185">PROVA PAZIENTE3</TD><TD width="280">ISENTRESS*400MG 60CPR</TD><TD width="141">14/12/2019</TD><TD width="123">038312017</TD></TR><TR><TD width="82">67493</TD><TD width="185">PROVA PAZIENTE1</TD><TD width="280">TIVICAY*30CPR RIV 50MG</TD><TD width="141">14/01/2020</TD><TD width="123">043195015</TD></TR><TR><TD width="82">67494</TD><TD width="185">PROVA PAZIENTE1</TD><TD width="280">LAMIVUDINA MY*60CPR RIV 150MG</TD><TD width="141">14/01/2020</TD><TD width="123">040485029</TD></TR><TR><TD width="82">67495</TD><TD width="185">PROVA PAZIENTE2</TD><TD width="280">KIVEXA*600+300MG 30 CPR</TD><TD width="141">15/01/2020</TD><TD width="123">036644019</TD></TR><TR><TD width="82">67496</TD><TD width="185">PROVA PAZIENTE2</TD><TD width="280">ISENTRESS*400MG 60CPR</TD><TD width="141">16/01/2020</TD><TD width="123">038312017</TD></TR><TR><TD width="82">67497</TD><TD width="185">PROVA PAZIENTE1</TD><TD width="280">CELSENTRI*300MG 60CPR RIV</TD><TD width="141">14/02/2020</TD><TD width="123">038138083</TD></TR><TR><TD width="82">67498</TD><TD width="185">PROVA PAZIENTE3</TD><TD width="280">ISENTRESS*400MG 60CPR</TD><TD width="141">15/02/2020</TD><TD width="123">038312017</TD></TR><TR><TD width="82">67499</TD><TD width="185">PROVA PAZIENTE2</TD><TD width="280">ZELITREX*21 CPR RIV. 1000 MG</TD><TD width="141">16/02/2020</TD><TD width="123">029503024</TD></TR></TBODY></TABLE><P> </P><P>I want to count whenever a  PATIENT has therapy changes (DIFFERENT PHARMA_CODE) between two delivery dates (DATA_DEL).</P><P>In the example the </P><P>PROVA PAZIENTE1 have n.3 CHANGES</P><P>PROVA PAZIENTE2 have n.1 CHANGE</P><P>PROVA PAZIENTE3 have n.0 CHANGE</P><P><SPAN>Can you give me the correct expression/script for count these occurences?</SPAN></P> Tue, 03 Mar 2020 12:01:46 GMT gabroteddy 2020-03-03T12:01:46Z HOW CALCULATE CHANGE BETWEEN TWO DATES https://community.qlik.com/t5/QlikView/HOW-CALCULATE-CHANGE-BETWEEN-TWO-DATES/m-p/1681265#M506632 <P>Hi at all,</P><P>i want count how many times a patient change therapy.</P><P>I have a table like this (i attach the excel file):</P><TABLE width="811"><TBODY><TR><TD width="82">NUMMOV</TD><TD width="185">PATIENT</TD><TD width="280">DESCR</TD><TD width="141">DATA_DEL</TD><TD width="123">PHARMA_CODE</TD></TR><TR><TD width="82">67489</TD><TD width="185">PROVA PAZIENTE1</TD><TD width="280">ZELITREX*21 CPR RIV. 1000 MG</TD><TD width="141">19/12/2017</TD><TD width="123">029503024</TD></TR><TR><TD width="82">67490</TD><TD width="185">PROVA PAZIENTE2</TD><TD width="280">KIVEXA*600+300MG 30 CPR</TD><TD width="141">18/12/2018</TD><TD width="123">036644019</TD></TR><TR><TD width="82">67491</TD><TD width="185">PROVA PAZIENTE2</TD><TD width="280">ISENTRESS*400MG 60CPR</TD><TD width="141">18/12/2018</TD><TD width="123">038312017</TD></TR><TR><TD width="82">67492</TD><TD width="185">PROVA PAZIENTE3</TD><TD width="280">ISENTRESS*400MG 60CPR</TD><TD width="141">14/12/2019</TD><TD width="123">038312017</TD></TR><TR><TD width="82">67493</TD><TD width="185">PROVA PAZIENTE1</TD><TD width="280">TIVICAY*30CPR RIV 50MG</TD><TD width="141">14/01/2020</TD><TD width="123">043195015</TD></TR><TR><TD width="82">67494</TD><TD width="185">PROVA PAZIENTE1</TD><TD width="280">LAMIVUDINA MY*60CPR RIV 150MG</TD><TD width="141">14/01/2020</TD><TD width="123">040485029</TD></TR><TR><TD width="82">67495</TD><TD width="185">PROVA PAZIENTE2</TD><TD width="280">KIVEXA*600+300MG 30 CPR</TD><TD width="141">15/01/2020</TD><TD width="123">036644019</TD></TR><TR><TD width="82">67496</TD><TD width="185">PROVA PAZIENTE2</TD><TD width="280">ISENTRESS*400MG 60CPR</TD><TD width="141">16/01/2020</TD><TD width="123">038312017</TD></TR><TR><TD width="82">67497</TD><TD width="185">PROVA PAZIENTE1</TD><TD width="280">CELSENTRI*300MG 60CPR RIV</TD><TD width="141">14/02/2020</TD><TD width="123">038138083</TD></TR><TR><TD width="82">67498</TD><TD width="185">PROVA PAZIENTE3</TD><TD width="280">ISENTRESS*400MG 60CPR</TD><TD width="141">15/02/2020</TD><TD width="123">038312017</TD></TR><TR><TD width="82">67499</TD><TD width="185">PROVA PAZIENTE2</TD><TD width="280">ZELITREX*21 CPR RIV. 1000 MG</TD><TD width="141">16/02/2020</TD><TD width="123">029503024</TD></TR></TBODY></TABLE><P> </P><P>I want to count whenever a  PATIENT has therapy changes (DIFFERENT PHARMA_CODE) between two delivery dates (DATA_DEL).</P><P>In the example the </P><P>PROVA PAZIENTE1 have n.3 CHANGES</P><P>PROVA PAZIENTE2 have n.1 CHANGE</P><P>PROVA PAZIENTE3 have n.0 CHANGE</P><P><SPAN>Can you give me the correct expression/script for count these occurences?</SPAN></P> Tue, 03 Mar 2020 12:01:46 GMT https://community.qlik.com/t5/QlikView/HOW-CALCULATE-CHANGE-BETWEEN-TWO-DATES/m-p/1681265#M506632 gabroteddy 2020-03-03T12:01:46Z Re: HOW CALCULATE CHANGE BETWEEN TWO DATES https://community.qlik.com/t5/QlikView/HOW-CALCULATE-CHANGE-BETWEEN-TWO-DATES/m-p/1690051#M506633 <P>See duplicate post: <A href="https://community.qlik.com/t5/QlikView-Scripting/COUNT-CHANGE-BETWEEN-TWO-DATES/m-p/1681262#M98458" target="_blank">https://community.qlik.com/t5/QlikView-Scripting/COUNT-CHANGE-BETWEEN-TWO-DATES/m-p/1681262#M98458</A></P><P>Regards,<BR />Brett</P> Wed, 01 Apr 2020 20:26:54 GMT https://community.qlik.com/t5/QlikView/HOW-CALCULATE-CHANGE-BETWEEN-TWO-DATES/m-p/1690051#M506633 Brett_Bleess 2020-04-01T20:26:54Z