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: 
qlikvw2019
Contributor
Contributor

Date comparison in expression

New to Qlikview , please help

1) Need to display only for the last 20 days.

=only({[completion_date] <  sysdate-20)

 

2) Add AND condition to the above experssion,  column2=bigdata"plus" , Bigdata plus has double quotes in it.

7 Replies
sunny_talwar

Is this something you use as a dimension or expression?

qlikvw2019
Contributor
Contributor
Author

Expression 

sunny_talwar

Is this the exact expression you are using? 

=only({[completion_date] <  sysdate-20)

What do you get when you use this?

qlikvw2019
Contributor
Contributor
Author

This is not the exact expression. This is simply what i am looking for.

sunny_talwar

Might be easy to help if you can share the exact expression if it is not immensely complex

qlikvw2019
Contributor
Contributor
Author

Below is the working example of an expression in a straight Table.

=only([READY_STATUS]='GO')

I am looking for a similar one for Date

sunny_talwar

So, this expression must be giving you a -1 and 0, correct?