Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gleybson_calyx
Contributor III
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
swuehl
MVP
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 )

View solution in original post

5 Replies
petter
MVP
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 )

gleybson_calyx
Contributor III
Contributor III
Author

Did not work.

Follow the picture.ErroSense.png

swuehl
MVP
MVP

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

The Magic of Variables

The Little Equals Sign

gleybson_calyx
Contributor III
Contributor III
Author

ErroSenseVariable.png

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

View solution in original post