Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone!
I have the following fields in my master calendar.
Master Calendar:
Load
Date(TempDate) As "Date",
Day(TempDate) As Day
Date(TempDate - 7*52) As Date_Equivalent
The Date_Equivalent field results in a date from the previous year that equals the same day of the week as the current date as shown in the image below.
I want to display in the same bar chart with the day dimension the sales of the current year and the sales on the equivalent date of the last year. So here are my questions. Using set analysis is qlik sense able to sum sales by filtering the dates from the Date_Equivalent field? How can I do this in set analysis? If not, is there any other solution?
