Button for navigation (select multiple values)

[ali_hijazi]

Hello I'm working on Qlik Sense (latest version)
we already installed the Dashboard bundle extensions

I have a field called MONTH_YEAR which is derived using MonthName() function
Now I want to use the button for navigation to select all values that are greater than or equal to MonthName(Today())

in the Value I put the following expression:
=Concat({<MONTH_NUM={">=$(=num(MonthName(today())))"}>} distinct MONTH_YEAR,';')

which is returning the following values:

However when I click the button nothing occurs
kindly advise

[Anil_Babu_Samineni]

Try this?

='(' & Concat(DISTINCT {<MONTH_NUM={">=$(=num(MonthName(today())))"}>} Chr(34) & MONTH_YEAR & Chr(34),' | ') & ')'

[ali_hijazi]

doesn't work

[daanciorea]

The Loveisfail solution should be correct, but try this
='(' &chr(39)& Concat(DISTINCT {<MONTH_NUM={">=$(=num(MonthName(today())))"}>} Chr(34) & MONTH_YEAR & Chr(34),chr(39)&' | 'chr(39)) &chr(39)& ')'

[ali_hijazi]

also doesn't work, the button does nothing

[ali_hijazi · Accepted solution]

it works but I need to select the option select a value in a field instead of select multiple values in a field 

and I had to update the syntax which is as follows:
= '(' & Concat(DISTINCT {<MONTH_NUM={">=$(=num(MonthName(today())))"}>} Chr(34) & MONTH_YEAR & Chr(34) ,'|') & ')'

Thank you very much indeed

[Anil_Babu_Samineni]

@ali_hijazi  Please do correct flag which can help? Why mine is wrong and yours is correct?

[heij1421]

In my solution I needed an expression to select all month from January until this month. This was the outcome and it worked:

="'" & Concat(DISTINCT {$<Month = {"<=$(=NUM(Month(Today())))"} >}[Month No] & ';') & "'"

[roshnirao]

Hi Ali,

How can I pass 2 date values in the filter column?