Discussion board where members can get started with Qlik Sense.
I want to build PIVOT table using following data:
When I choose Month and Year on the filter pane, I want the PIVOT to show me [Revenue] for:
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.
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).