MTD and PMTD

[Anonymous]

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))

[Chanty4u]

https://community.qlik.com/docs/DOC-17974

[Anonymous]

Hi Lina,

Can you share sample data and expected result?

Thanks