Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Contributor III

past the date

Hi all,

Tresesco B

I want to display the details

where the completedate is past from now()

means : 

is anything need to change in exP?

Tags (3)
4 Replies
MVP
MVP

Re: past the date

Second parameter of interval is a format. Try like:

aggr( Interval(CompletionDate-now(),'dd:hh:mm:ss'),numb)

soniasweety
Contributor III

Re: past the date

here

       it past the now()  then display the number values

completedate
2017-08-01 03:59:59
2017-09-22 15:45:19
2017-09-22 15:46:29
2017-09-22 15:56:30
2017-08-02 18:29:59
2017-08-02 18:29:59
2017-08-02 18:29:59
2017-08-02 18:29:59
2017-08-02 18:29:59
2017-08-02 18:29:59
2017-09-05 18:38:00
2017-09-05 18:39:39
MVP
MVP

Re: past the date

if one numb has one date , try like:

=if(CompletionDate-today()>0,numb)


Note: Now() is performance killing, don't use it unless you really need it. If you are looking for current date, use today().

soniasweety
Contributor III

Re: past the date

thanks.  its working    but I need to check its now()/CurrentDate

thanks for suggestions towards performance.