# App Development

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for
Did you mean:
Contributor III

## Set Analysys for Date

Friends,

why is not this measure working?

Sum ({<VENCTO = {'<\$ (vToday)'}>} ValorVencto)

Field VENCTO = DD/MM/YYYY

Variable = Date(Today(), 'DD/MM/YYYY')

If I put Sum ({<'24/01/2018'= {'\$(vToday)'}>} ValorVencto) It works

Sum ({<VENCTO = {'24/01/2018'}>} ValorVencto) It works

I have tried in several ways like:

Sum ({<VENCTO_ANOMESDIA = {'<\$(vToday)'}>} ValorVencto)

Field VENCTO = YYYYMMDD

Variable = Date(Today(), 'YYYYMMDD')

Sum ({<VENCTO_NUM = {'<\$(vToday)'}>} ValorVencto)

Field VENCTO = 43124

Variable = NUM(Date(Today(), 'YYYYMMDD'))

NONE OF THESE MEASURES WORKED.

What am I doing wrong?

1 Solution

Accepted Solutions
MVP

You should definitely use double quotes if you want to use a search:

Quotes in Set Analysis

And also have a look at

Dates in Set Analysis

So, in total try

Sum( {<VENCTO={"<\$(vToday)"}>} ValorVencto )

5 Replies
MVP

Have you tried to move the first single quotation mark to steps to the right like this and enclosing the entire search in double quotation marks. You can not have a space between the \$ and the ( either:

Sum( {<VENCTO={"<'\$(vToday)'"}>} ValorVencto )

Contributor III
Author

Did not work.

MVP

Have you defined your variable with a leading equal sign or without?

The Magic of Variables

The Little Equals Sign

Contributor III
Author

MVP

You should definitely use double quotes if you want to use a search:

Quotes in Set Analysis

And also have a look at

Dates in Set Analysis

So, in total try

Sum( {<VENCTO={"<\$(vToday)"}>} ValorVencto )