Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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;