# 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])

Tags (1)
1 Solution

Accepted Solutions
Contributor

## Re: Using function today () in set analysis?

Hi Joao,

Have you tried

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

?

Regards, Janneke.

8 Replies
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.

MVP

## 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

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

Contributor

## Re: Using function today () in set analysis?

Hi Joao,

Have you tried

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

?

Regards, Janneke.

Not applicable

Thanks!