Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Pick and Match Function (Lookup)

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

H

1 Solution

Accepted Solutions

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

See attached qvw.


talk is cheap, supply exceeds demand
4 Replies

Re: Pick and Match Function (Lookup)

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)


talk is cheap, supply exceeds demand
Not applicable

Re: Re: Pick and Match Function (Lookup)

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)

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

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

Many thanks Gysbert,

Its working perfectly, much appreciated

H

Community Browser