Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

line chart x axis restrict date value

I want to restrict the dates on my Y axis to a range on my line chart.

Attached is my graph. If I want the dates from 10/4/2014 to 1/2/2015 only, how to achieve it?

1 Reply
JonnyPoole
Former Employee
Former Employee

In the sample below i use a sum( if() ) to only show the expression values that have a date higher than the a set date.

The top chart is all dates, the bottom is filtered in this way.

The expression is as follows:   sum( if(  Date >= date(makedate(2009,06,15)), Sales))

You would have to do the if condition on all expressions.

Capture.PNG.png