Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

How to write a date Expression

Morning all,

I am working with some data that has dates attached unfortunately for 1 reason or another there are many that contain 01/01/1900 and I want to omit those from the data as this is just rubbish.

Is there a quick expression that I can put in ?



Labels (1)
2 Replies
Contributor II
Contributor II

I believe what you are after for this is something along the lines of:


=sum({<[date] ={">01/01/1900"}>}[value])


the important part her is the [date]={">01/01/1900"}  which is telling the measure to only bring back values where the date is greater than 01/01/1900

Contributor II
Contributor II

Hi, thanks for the reply, sorry I didn't explain myself very well.

I am building a table with columns in and its the date column where I want to remove the 1900's

I feel I need to do an if statement but not sure how it would be written