Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List of Values

Hello,

I have a box with list of values based on a column in my database.

I want to exclude certain values in the list box. e.g.

List box with data

2015-01-01

2015-01-02

2015-01-03

etc.

i want to exclude all data with date befor 2015-01-03. How can i do that?

2 Replies
petter
Partner - Champion III
Partner - Champion III

Instead of adding the Field you can select expression from the drop down when you create your list box.

=If( aDate >= MakeDate(2015,1,3) , aDate )

Then you will filter out older dates...

crystles
Partner - Creator III
Partner - Creator III

Yes if you just use a formula when you load the field then it will limit the date of the fields being added.

Field

Field

if(DateField <= Date(2015-01-03), DateField) as DateField

Field