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: 
darielly
Contributor
Contributor

(Noob question) How do I change a field to display specific date ranges?

Hello all, 

Apologies for the basic question, I'm quite new to this; I'm making a practice app using some sales data but of course have a great big history of sales (ranging back yeas!). For the sake of the app, I want to make it so that I can display certain years onward and was wondering what the best way of doing this would be? 

I'm using our delivery date field as a guideline for when the sale was completed but want to use 2019 as an example range. Would I need to do this from the data load or simply as an expression in the delivery date field on the chart? Could I add a year/month filter so that I could quickly show other ranges? 

Thanks for your time! 

Labels (4)
1 Reply
Lisa_P
Employee
Employee

best place to limit the data is in the data load.

Use a condition in the load or select statement to do this like:

Load ...

Where Year([delivery date])>2018;