topic Re: Date comparison in expression in QlikView

Date comparison in expression

qlikvw2019 — Wed, 25 Nov 2020 16:16:04 GMT

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.

sunny_talwar — Thu, 20 Jun 2019 14:45:31 GMT

Is this something you use as a dimension or expression?

qlikvw2019 — Thu, 20 Jun 2019 15:11:45 GMT

Expression

sunny_talwar — Thu, 20 Jun 2019 15:20:23 GMT

Is this the exact expression you are using?

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

What do you get when you use this?

qlikvw2019 — Thu, 20 Jun 2019 15:22:39 GMT

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

sunny_talwar — Thu, 20 Jun 2019 15:43:25 GMT

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

qlikvw2019 — Thu, 20 Jun 2019 16:36:58 GMT

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 — Thu, 20 Jun 2019 19:27:46 GMT

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