count change between two dates

gabroteddy — Wed, 25 Nov 2020 16:16:04 GMT

Hi at all,

i want count how many times a patient change therapy.

I have a table like this (i attach the excel file):

NUMMOV	PATIENT	DESCR	DATA_DEL	PHARMA_CODE
67489	PROVA PAZIENTE1	ZELITREX*21 CPR RIV. 1000 MG	19/12/2017	029503024
67490	PROVA PAZIENTE2	KIVEXA*600+300MG 30 CPR	18/12/2018	036644019
67491	PROVA PAZIENTE2	ISENTRESS*400MG 60CPR	18/12/2018	038312017
67492	PROVA PAZIENTE3	ISENTRESS*400MG 60CPR	14/12/2019	038312017
67493	PROVA PAZIENTE1	TIVICAY*30CPR RIV 50MG	14/01/2020	043195015
67494	PROVA PAZIENTE1	LAMIVUDINA MY*60CPR RIV 150MG	14/01/2020	040485029
67495	PROVA PAZIENTE2	KIVEXA*600+300MG 30 CPR	15/01/2020	036644019
67496	PROVA PAZIENTE2	ISENTRESS*400MG 60CPR	16/01/2020	038312017
67497	PROVA PAZIENTE1	CELSENTRI*300MG 60CPR RIV	14/02/2020	038138083
67498	PROVA PAZIENTE3	ISENTRESS*400MG 60CPR	15/02/2020	038312017
67499	PROVA PAZIENTE2	ZELITREX*21 CPR RIV. 1000 MG	16/02/2020	029503024

I want to count whenever a PATIENT has therapy changes (DIFFERENT PHARMA_CODE) between two delivery dates (DATA_DEL).

In the example the

PROVA PAZIENTE1 have n.3 CHANGES

PROVA PAZIENTE2 have n.1 CHANGE

PROVA PAZIENTE3 have n.0 CHANGE

Can you give me the correct expression for count these occurences?

Re: count change between two dates

Brett_Bleess — Wed, 01 Apr 2020 16:41:32 GMT

I would suggest you browse/search in the Design Blog area, you will likely find some examples there to assist you with things.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Just use the search box to look for related posts, I would recommend starting with a single word, see what comes back and narrow from there using other words. There are hundreds of posts in this area, mostly how-to, so something here should likely get you on the right track.

Regards,
Brett

topic count change between two dates in QlikView

count change between two dates

Re: count change between two dates