topic Re: On Open with Select in Field in QlikView

On Open with Select in Field

tim_at_ford — Fri, 12 Apr 2019 19:22:41 GMT

Hey everyone!

I've got this Select in Field condition as such:

And this work fine when it comes Month but I want to add on the year as well for my MonthYear selection:

='=Year=year(today())'

Essentially I want to do this:

='=Month=month(today())' plus ='=Year=year(today())'

So my "MonthYear" field will be populated correctly. The on open search is working correctly for each. I just want to combine them.

It's a syntax question and sorry for the elementary nature!!

Re: On Open with Select in Field

sunny_talwar — Fri, 12 Apr 2019 19:25:44 GMT

May be do it on the MonthYear field? or do it with two select in field actions?

Re: On Open with Select in Field

dplr-rn — Fri, 12 Apr 2019 19:41:04 GMT

this is what has worked for me before

date(monthstart(today()), 'MMM-YYYY') - to set current month

but this assumes your year month is in date format.

whats the format of your year month field?

Re: On Open with Select in Field

tim_at_ford — Fri, 12 Apr 2019 19:41:31 GMT

Sunny!!

OH YEA BABY, BABY!!

That worked!!! Thank you sir!!

Re: On Open with Select in Field

tim_at_ford — Fri, 12 Apr 2019 19:42:29 GMT

Thank you for your reply Dilipranjith we got it working!!