Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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