Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
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!
Yes, introducing a Year field in the data model should make it work.
Alternatively, one can use a search string like
Thank you Francesco this worked very well.
This looks good too. I wish I could mark both correct. I can see the logic in the string work around. very helpful.