# Qlik Sense App Development

New 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?

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: Set Analysys for Date

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

## Re: Set Analysys for Date

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 )

New Contributor III

Did not work.

MVP

## Re: Set Analysys for Date

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

The Magic of Variables

The Little Equals Sign

New Contributor III

MVP

## Re: Set Analysys for Date

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 )