I am trying to show Daily and Monthy Comparison between Current Year and Previous Year in a Pivot table in QlikSense.
We have all the Calendar fields (Date, Month, Year, Month-Year etc) in a dimension called DimDate. We have a Fact table storing the transactions. Date is common between DimDate and Fact.
I tried to show the following in Pivot table and did not succeed.
Turnover Last Year
I tried using set analysis, but did not succeed as the date related tables are present in the chart.
Is there a way do it?
Below is an example of How it should look like.
|Month||Date||Machine Turnover||Machine Turnover Last year||Variance|
|(when expanded to date)||01/06/2017||$370,590||$276,170||$94,420|