topic Re: Using function today () in set analysis? in QlikView

Using function today () in set analysis?

Fri, 05 Apr 2013 18:48:14 GMT

Good Afternoon,

I wonder how can I use the function analysis on set today?

I need to return in a text object the delinquent amount until the present day.

Ex: sum ({<[Due Date] = {$ (= Today ())}>} [Pending Value])

Already Thank you!

Re: Using function today () in set analysis?

srinivasa1 — Fri, 05 Apr 2013 18:52:36 GMT

Try as below

sum({<({<[Due Date]={'$(=$(=(Today()) )'}>}[Pending Value]))

For untill today you can write as below

sum({<({<[Due Date]<={'$(=$(=(Today()) )'}>}[Pending Value]))

Re: Using function today () in set analysis?

Fri, 05 Apr 2013 19:00:58 GMT

Hello,
tested and did not return anything!

Att,

João Henrique

Re: Using function today () in set analysis?

Fri, 05 Apr 2013 19:05:42 GMT

HI ,

Use this code .

sum ({<[Due Date] = {'$ (= Today ())'}>} [Pending Value])

Please let me know if there is anything.

Re: Using function today () in set analysis?

MayilVahanan — Fri, 05 Apr 2013 19:06:55 GMT

Try like this

sum ({<[Due Date] = {"<=$ (= Today ())"}>} [Pending Value])

And make sure, both [due date] and today() are in same format

Hope it helps

Re: Using function today () in set analysis?

Anonymous — Fri, 05 Apr 2013 20:37:46 GMT

This should work:

sum ({<[Due Date] = {"$ (= date(Today ()))"}>} [Pending Value])

Regards,

Michael

Re: Using function today () in set analysis?

Fri, 05 Apr 2013 21:16:31 GMT

Thank you all for the help...

Att,

João Henrique

Re: Using function today () in set analysis?

Janneke — Thu, 06 Nov 2014 14:27:59 GMT

Hi Joao,

Have you tried

=Sum({<[Due Date]={'<=$(=Date(Today()))'}>}[Pending Value])

Regards, Janneke.

Re: Using function today () in set analysis?

Tue, 18 Nov 2014 19:27:07 GMT

Thanks!