Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variable lookup

I want to find the value of a field in a table based on the value of today also in the same table.

Table (PeriodCalendar) has these fields:

          Date          FinPer

          15/04/15     01

          16/01/15     01

          04/02/15     02

          etc....

So I need a variable that defines the FinPer for today

e.g. if today is 04/02/15 I want my variable to be 02

Thanks for your help

1 Solution

Accepted Solutions
gautik92
Specialist III
Specialist III

Have a look at this

View solution in original post

2 Replies
gautik92
Specialist III
Specialist III

Have a look at this

MK_QSL
MVP
MVP

Define your variable as below

=FirstSortedValue(FinPer,-Date(Date#(Date,'DD/MM/YY')))

or

=FirstSortedValue(FinPer, -IF(Date(Date#(Date,'DD/MM/YY'))=Date(Today()),Date(Date#(Date,'DD/MM/YY'))))