topic Re: Re: Pick and Match Function (Lookup) in QlikView

Pick and Match Function (Lookup)

Mon, 05 May 2014 17:35:15 GMT

Hi All,

I have a table which has say two columns Date & Day number (this has no relation to normal day numbers). How can I write an expression say in a text box that tells me what day number today is using pick and match functions or any other alternative.

Thank you

Re: Pick and Match Function (Lookup)

Gysbert_Wassenaar — Mon, 05 May 2014 17:44:05 GMT

You don't need pick and/or match. Try something like this:

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

If your Data field doesn't contain dates but strings you may need something like:

=only({<Date={'$(=date(today(),'MM/DD/YYYY'))'}>} DayNumber)

Re: Re: Pick and Match Function (Lookup)

Mon, 05 May 2014 17:57:21 GMT

Thanks Gysbert,

Unfortunately, I can't quite get it to work. I have attached some dummy data.

Thanks

Re: Re: Re: Pick and Match Function (Lookup)

Gysbert_Wassenaar — Mon, 05 May 2014 18:04:47 GMT

See attached qvw.

Re: Re: Re: Pick and Match Function (Lookup)

Mon, 05 May 2014 19:00:23 GMT

Many thanks Gysbert,

Its working perfectly, much appreciated