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.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kelly_oakley
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 ?

 

thanks

Labels (1)
2 Replies
C_Howarth
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

kelly_oakley
Contributor II
Contributor II
Author

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