Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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.

Labels (1)
7 Replies
sunny_talwar
MVP
MVP

Is this something you use as a dimension or expression?

qlikvw2019
Contributor
Contributor
Author

Expression 

sunny_talwar
MVP
MVP

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
MVP
MVP

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
MVP
MVP

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