topic Re: Current Year using Select Field Action with Search string? in QlikView

Current Year using Select Field Action with Search string?

Tue, 15 Jan 2013 16:40:05 GMT

Hi,

I haven't seen anything that works in my scenario below.

I have a button that suppose to dynamically select the current year. Currently its hard coded as *2012* with wild cards which is the only thing that works..

I would like to use something like this: Year(Today())

But nothing happens. I'm sure my syntax incorrect.

Re: Current Year using Select Field Action with Search string?

francescopuppin — Tue, 15 Jan 2013 16:47:46 GMT

Hi Brian,

in my opinion the cleanest solution is to

1) add a field in the script

Year(ModEffDate) AS ModEffYear

2) Change your Action: Select in Field: ModEffYear. the search string is OK

This will solve your problem.

In alternative probably it can be done without adding that field... but let's be honest: it is always nice to have the Year field!

Re: Current Year using Select Field Action with Search string?

swuehl — Tue, 15 Jan 2013 16:51:34 GMT

Yes, introducing a Year field in the data model should make it work.

Alternatively, one can use a search string like

='=year(ModEffDate)=year(today())'

Regards,

Stefan

Re: Current Year using Select Field Action with Search string?

Tue, 15 Jan 2013 18:36:49 GMT

Thank you Francesco this worked very well.

Re: Current Year using Select Field Action with Search string?

Tue, 15 Jan 2013 18:40:12 GMT

Stefan,

This looks good too. I wish I could mark both correct. I can see the logic in the string work around. very helpful.