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?

View solution in original post

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?

View solution in original post

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