Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

MTD and PMTD

How do you get to show all the Months if you are doing a comparison of CMTD with PMTD

using these Expression because now it only calculate for the Current and Previous monthly only e.g

it calculates for July and June but i want it to do for all these other months for instance January, Feb,Mar,May,June,July

FOR CURRENT MONTH:

=Count({<YEAR={'$(MaxYear)'},MONTH = {'$(MaxMonth)'}>} DISTINCT(PORT_ICCID))

PREVIOUS MONTH:

=Count({<YEAR={'$(MaxYear)'},MONTH = {'$(vPriorMonth)'}>} DISTINCT(PORT_ICCID))

2 Replies
Anonymous
Not applicable
Author

Hi Lina,

Can you share sample data and expected result?

Thanks