Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Function for capture date 1 week before.

Hi,

I have dashboard weekly reporting, and the simple table is below:

DateService Quality
01/01/1712
02/01/1713
03/01/1733
04/01/1743
05/01/1772
06/01/1711
07/01/1747
08/01/1767
09/01/1721
10/01/1752

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.

1 Reply
vinieme12
Esteemed Contributor II

Re: Function for capture date 1 week before.

create flags in load sript using week() function

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/w...

Then in set analysis restrict the week number you want to show data for for example MaX(WeekNum)-1  !!