Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Using function today () in set analysis?

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!

Tags (1)
1 Solution

Accepted Solutions
janneke_
Contributor

Re: Using function today () in set analysis?

Hi Joao,

Have you tried

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

?

Regards, Janneke.

8 Replies
srinivasa1
Contributor

Re: Using function today () in set analysis?

Try as below

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

For untill today you can write as below

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

Not applicable

Re: Using function today () in set analysis?

Hello,
tested and did not return anything!

Att,

João Henrique

Not applicable

Re: Using function today () in set analysis?

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?

HI

Try like this

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

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

Hope it helps

mov
Esteemed Contributor III

Re: Using function today () in set analysis?

This should work:

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

Regards,

Michael

Not applicable

Re: Using function today () in set analysis?

Thank you all for the help...

Att,

João Henrique

janneke_
Contributor

Re: Using function today () in set analysis?

Hi Joao,

Have you tried

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

?

Regards, Janneke.

Not applicable

Re: Using function today () in set analysis?

Thanks!

Community Browser