topic Re: Button for navigation (select multiple values) in App Development

Button for navigation (select multiple values)

ali_hijazi — Wed, 08 May 2019 07:34:45 GMT

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

Re: Button for navigation (select multiple values)

Anil_Babu_Samineni — Wed, 08 May 2019 11:54:00 GMT

Try this?

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

Re: Button for navigation (select multiple values)

ali_hijazi — Thu, 09 May 2019 10:12:39 GMT

doesn't work

Re: Button for navigation (select multiple values)

daanciorea — Thu, 09 May 2019 10:21:00 GMT

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)& ')'

Re: Button for navigation (select multiple values)

ali_hijazi — Thu, 09 May 2019 10:23:51 GMT

also doesn't work, the button does nothing

Re: Button for navigation (select multiple values)

ali_hijazi — Thu, 09 May 2019 10:32:30 GMT

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

Re: Button for navigation (select multiple values)

Anil_Babu_Samineni — Fri, 31 May 2019 15:11:14 GMT

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

Re: Button for navigation (select multiple values)

heij1421 — Sat, 12 Oct 2019 17:12:52 GMT

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] & ';') & "'"

Re: Button for navigation (select multiple values)

roshnirao — Wed, 19 Feb 2020 17:28:19 GMT

Hi Ali,

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