topic Re: Creating a Concatenated String of Values for a Trigger (Select in Field) in QlikView

Creating a Concatenated String of Values for a Trigger (Select in Field)

jcs_2015 — Sat, 16 Nov 2024 03:42:27 GMT

I'm trying to generate a list of Values for a trigger (via a button) to select a rolling 12 month time frame. I've built the following and appear to get the proper results when viewed in a Text Box BUT I just can't seem to get the trigger to make the sections though

Output is: Apr 2019|Mar 2019|Feb 2019|Jan 2019|Dec 2018|Nov 2018|Oct 2018|Sep 2018|Aug 2018|Jul 2018|Jun 2018|May 2018

Thoughts on why the Trigger won't make selections? Any thoughts on a more elegant solution as well (front end only though)?

Thanks

Jim

Re: Creating a Concatenated String of Values for a Trigger (Select in Field)

sunny_talwar — Wed, 01 May 2019 12:03:34 GMT

Try this

to get this

("Apr 2019"|"Mar 2019"|"Feb 2019"|"Jan 2019"|"Dec 2018"|"Nov 2018"|"Oct 2018"|"Sep 2018"|"Aug 2018"|"Jul 2018"|"Jun 2018"|"May 2018")

or you can explore the option of using >=MonthYear<=MonthYear if your field is a date field with dual value.

Re: Creating a Concatenated String of Values for a Trigger (Select in Field)

jcs_2015 — Wed, 01 May 2019 14:00:03 GMT

Thanks Sunny, that works perfectly, as usual!

Can you explain, why the Concat function itself is included inside the ()? Is that the only way Qlik will recognize of string of values like this for selections via a trigger?

Re: Creating a Concatenated String of Values for a Trigger (Select in Field)

sunny_talwar — Wed, 01 May 2019 14:24:43 GMT

@jcs_2015 wrote:
Can you explain, why the Concat function itself is included inside the ()?

Because you need the final thing to look like this
("Apr 2019"|"Mar 2019"|"Feb 2019"|"Jan 2019"|"Dec 2018"|"Nov 2018"|"Oct 2018"|"Sep 2018"|"Aug 2018"|"Jul 2018"|"Jun 2018"|"May 2018")

This is the syntax Qlik requires for searching.

@jcs_2015 wrote:
Is that the only way Qlik will recognize of string of values like this for selections via a trigger?

Like I mentioned, if you have MonthYear as a date and time field, you can use >= <= to trigger

Re: Creating a Concatenated String of Values for a Trigger (Select in Field)

jcs_2015 — Wed, 01 May 2019 15:35:24 GMT

Thanks again, I'll work on the >= option too as I believe it is ultimately a cleaner solution