topic Re: How to create Calendar with current Month equal to last six month in QlikView

How to create Calendar with current Month equal to last six month

RishRish — Sat, 16 Nov 2024 19:28:55 GMT

Hi All,

I have requirement were user want see Bar chart with current month data adding last six month data in same month like that each and every month. we need keep on adding that month +six month in bar chart.

Thank you in advance

Re: How to create Calendar with current Month equal to last six month

zhadrakas — Wed, 11 Dec 2019 07:14:05 GMT

you should create an As-Of-Table.

See this thread:

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

Re: How to create Calendar with current Month equal to last six month

Apprentice4life — Wed, 11 Dec 2019 21:42:30 GMT

You can set your date range as variables and use them in your set analysis expression for the bar chart.

variable1 = Max(CalendarField) , the most current month
variable2 = Addmonths(variable1, -5), Date 6 months ago

SUM({<CalendarField = {">=$(variable2)<=$(variable1)"}>}Data)

Be aware of the format of the CalendarField, whether it is a date or text string. It matters.

Hope this work for you!

Re: How to create Calendar with current Month equal to last six month

Brett_Bleess — Wed, 18 Dec 2019 14:31:56 GMT

Here is another Design Blog post that may be a better fit:

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581

Here is the base Design Blog URL as well in case you want to search further on your own:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

If one of the posts already helped you with your use case, do not forget to return to things and use the Accept as Solution button on the post(s) that helped you get what you needed, as this gives credit to the poster and lets other Community Members know what worked.

Regards,
Brett