Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
tim_at_ford
New Contributor III

On Open with Select in Field

Hey everyone!

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

 

Select in Field Popup.PNG

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!!

 

 

 

Tags (2)
1 Solution

Accepted Solutions

Re: On Open with Select in Field

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

4 Replies

Re: On Open with Select in Field

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

Partner
Partner

Re: On Open with Select in Field

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?
tim_at_ford
New Contributor III

Re: On Open with Select in Field

Sunny!!

OH YEA BABY, BABY!!

That worked!!!  Thank you sir!!

 

tim_at_ford
New Contributor III

Re: On Open with Select in Field

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