topic Re: Last 7 Days MTD Value in QlikView

Last 7 Days MTD Value

ahmed_zeidan — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Last 7 Days MTD Value

Arthur_Fong — Thu, 03 Oct 2019 05:39:37 GMT

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

Re: Last 7 Days MTD Value

Brett_Bleess — Wed, 09 Oct 2019 16:33:22 GMT

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