Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Is this something you use as a dimension or expression?
Expression
Is this the exact expression you are using?
=only({[completion_date] < sysdate-20)
What do you get when you use this?
This is not the exact expression. This is simply what i am looking for.
Might be easy to help if you can share the exact expression if it is not immensely complex
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
So, this expression must be giving you a -1 and 0, correct?