Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ziabobaz
Contributor II

CYMTD vs PYMTD in one single measure

Hi,

I want to build PIVOT table using following data:

Screenshot_38.jpg

Rows: Measures

Columns: MonthYear

Measures: [Revenue]

When I choose Month and Year on the filter pane, I want the PIVOT to show me [Revenue] for:

  • CYMTD in the first column
  • PYMTD in the second column
  • Difference in the third column


Let's say I chose MARCH and 2017. There are only 7 days with the data, the [Revenue] measure would be calculated for 1-7 days of March in 2017 vs 2016, and the difference.

So far, I was only able to create two different [Revenue] measures for CY and PY, but this does not work for me.

Tags (4)
6 Replies
shraddha_g
Honored Contributor III

Re: CYMTD vs PYMTD in one single measure

In column you can give 'Year' and Month/MonthYear Dimension and for selection give Month instead of MonthYear

OmarBenSalem
Esteemed Contributor

Re: CYMTD vs PYMTD in one single measure

Something like this would do it?

Capture.PNG

ziabobaz
Contributor II

Re: CYMTD vs PYMTD in one single measure

I don't quite get it how it will help me with my problem. I already have MONTLY data in the layout I want.

The problem is that is can't figure out how i can get MTD numbers for the single measure and how can i get DIFFERENCE column in PIVOT (I know how to do it in table).

Screenshot_39.jpg

OmarBenSalem
Esteemed Contributor

Re: CYMTD vs PYMTD in one single measure

If this does the work, I can help with it

Capture.PNG

ziabobaz
Contributor II

Re: CYMTD vs PYMTD in one single measure

look great except i need to switch MOD and Measure, like in the screenshot above.

How did you make the difference measure, though?

andyrea1000
New Contributor

Re: CYMTD vs PYMTD in one single measure

Hi, where you able to solve this? i have the same issue, but cant work it out....

please post solution if you can

 

thanks Andy