Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
RishRish
Contributor
Contributor

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

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. 

 

Capture.PNG 

 

Thank you in advance 

1 Solution

Accepted Solutions
zhadrakas
Specialist II
Specialist II

3 Replies
zhadrakas
Specialist II
Specialist II

Apprentice4life
Contributor II
Contributor II

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!

Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.