Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have dashboard weekly reporting, and the simple table is below:
Date | Service Quality |
---|---|
01/01/17 | 12 |
02/01/17 | 13 |
03/01/17 | 33 |
04/01/17 | 43 |
05/01/17 | 72 |
06/01/17 | 11 |
07/01/17 | 47 |
08/01/17 | 67 |
09/01/17 | 21 |
10/01/17 | 52 |
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/DateAndT..., but no function meet with my question.
Thank You.
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 !!