Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
JoshD1
Contributor II
Contributor II

Pass multiple values to a Listbox

Hello gurus

I am an old time user of QlikView and trying to move to QlikSense,

In QlikView i have a trigger (or a button with similar actions) that upon activation  passes multiple values to a Listbox and those values will be selected.

For instance, upon opening a tab or clicking a button the following code is run and values are passed to a list box that displays Months:

(The code selects current months into a field MonthYear for the months Jan - Current Month)

='("'& Concat(DISTINCT {1} if(MonthYear>=MonthName(YearStart(Today())) AND MonthYear<=MonthName(Addmonths(Today(),0)),MonthYear),'"|"',MonthYear) &'")'

For today the filed MonthYear will be assigned the following values:

("Jan 2023"|"Feb 2023"|"Mar 2023"|"Apr 2023"|"May 2023")

Can that be duplicated in QlikSense?

In QlikSense I can pass ONE value to a field via the property Actions & Navigations. How do I pass multiple values?

Thanks

Labels (4)
2 Replies
Gabbar
Specialist
Specialist

i dont understand fully but as much as I got,
you can use define a variable,
The in custom objects you will find variable input-> appearance->variable->change show as from input box to drop down->in values change it from fixed to dynamic-> and then use your set expression as dynamic value.

Gabbar_0-1683392892969.png

 

JoshD1
Contributor II
Contributor II
Author

Thanks for attempting to help but that does not do it.

Maybe a better explanation is due: In QlikView I have a field named MonthYear in my Calendar which holds the values of the last 5 years -  Month (3 letters) followed by year like  Jan 2018, Feb 2018 ... Apr 2023, May 2023.

I also have a button that performs the action formula listed above which builds a string of months from YearStart to the current month. For 2023 the string is: ("Jan 2023"|"Feb 2023"|"Mar 2023"|"Apr 2023"|"May 2023") and assigns the string to the field MonthYear in Select In Field 

JoshD1_1-1683582122521.png

 

JoshD1_0-1683581756754.png

Can that be done in Qlik Sense?

Thanks

Josh