Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cscherer
Contributor
Contributor

last 6 month

Hello,

I want to create a chart, where I only see the data for the last 6 month. How can I create a new field with the last 6 month? I got two variables for the current month and for month-6, but I don`t know how to go on...

Thanks for your help in advance,
Clemens

1 Solution

Accepted Solutions
sreenivas
Creator III
Creator III

7 Replies
sreenivas
Creator III
Creator III

Check this file

cscherer
Contributor
Contributor
Author

ok, but how did you make it?

sreenivas
Creator III
Creator III

In dimension Limits Restrict the Number of Bars to be displayed and sort it in the yearmonth order

cscherer
Contributor
Contributor
Author

I see. But is it possible to have the current month on the right side of the chart?

sreenivas
Creator III
Creator III

Fimd the updated

cscherer
Contributor
Contributor
Author

thanks!

Not applicable

This doesn't quite work.

The data presented is displaying the largest 6 months.

Jan, Mar, Apr, May, Jun, Jul

As a result January is being displayed instead of February.

There is an option for first, but no one for last.

Any other solutions?