Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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