Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

UI Lookup Function

Hi All,

Was just wondering what the different lookup up functions there are for the front end. I have a table with dates and trading day numbers. I just need a function that can look at today's date (Today()) and tell me from the table what the corresponding trading day is.

I am currently using the function =only({<Date={'$(today())'}>} DayNumber) which I have made into a variable. This works fine when there are no selections that have been made in any list boxes. The problem is that when a user makes a selection from the any list boxes, it says error in expression, but deselect everything and it works again.

Independent of any selection, all I need is for the function to look up today's date in a table and return the corresponding trading day number.

Thank u

3 Replies

Re: UI Lookup Function

Try this

=only({1<Date={'$(today())'}>} DayNumber)

Not applicable

Re: Re: UI Lookup Function

Hi Celambarasan,

Unfortunately that returns and error. I have attached a copy of the some sample data.

Thanks for the help


New Contributor II

Re: UI Lookup Function

This may work for you

1.only({<Date={'$(vtoday)'},[Selling Day] =>}[Selling Day])

Community Browser