Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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