Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

gleybson_calyx
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
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
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 )

gleybson_calyx
New Contributor III

Re: Set Analysys for Date

Did not work.

Follow the picture.ErroSense.png

MVP
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

gleybson_calyx
New Contributor III

Re: Set Analysys for Date

ErroSenseVariable.png

MVP
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 )

Community Browser