
Anonymous
Not applicable
2018-07-12
10:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))
- Tags:
- qlikview_scripting
695 Views
2 Replies

MVP
2018-07-12
01:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
603 Views

Anonymous
Not applicable
2018-07-12
01:50 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Lina,
Can you share sample data and expected result?
Thanks
603 Views
