Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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 (5)
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;