- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
6 Month Trend Line Chart Help
Hi all,
I am using Qlik Sense and trying to create a 6 month dynamic line chart.
Right now my dimension is:
=date#(Month_Sort)
Month_Sort displays the date as 'YYYY-MMM'.
My measure is:
count({1<Date={'>=$(=AddMonths(Max(Date),-5)) <=$(=(Max(Date)))'}>}[Review Due Date])
The line chart shows all the data and not the most recent 6 months.
Can anyone help me with my issues?
Thanks,
Ale
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is your Date field format?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Ale,
I would recommend building a master calendar and creating a flag for the past 6 months. Then you can opt to ignore selections made in the application, such as other date fields and your chart is not impacted.
The chart would update for selections made in other fields such as departments, people, whatever is in your data. Maximizes your flexibility.
If this is of interest I'd be happy to share some code from a master calendar.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try to replace the simple quotes by double quotes
count({1<Date={">=$(=AddMonths(Max(Date),-5)) <=$(=(Max(Date)))"}>}[Review Due Date])