Last 7 Days MTD Value

[ahmed_zeidan]

Hello All, I am trying to find a solution, I have table which has the daily sales for each day, and I would like to show what is the MTD Values for the last 7 days in chart ? any help can be provided , Please refer for the screenshot for the sample data of and chart which is expected to be displayed

[Arthur_Fong · Accepted solution]

There you go:

Build the MTD column using peek() function.

Then, apply set analysis in the chart:

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

[Brett_Bleess]

Ahmed, did Arthur's post and example get you what you needed?  If so, do not forget to come back and use the Accept as Solution button to mark Arthur's post as correct and give him credit for the help.  

Here are some additional links on Set Analysis that may be helpful in the future as well as another post regarding setting up an As-Of-Table:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

Regards,
Brett