I have dashboard weekly reporting, and the simple table is below:
Today : 11/01/17 (for example)
- I want to create a bar chart, but only for 1 week before (04/01/17 - 10/01/17).
I already tried function on this link: https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/DateAndTimeFunctions.htm, but no function meet with my question.
create flags in load sript using week() function
Then in set analysis restrict the week number you want to show data for for example MaX(WeekNum)-1 !!