Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Can that be done in Qlik Sense?
Thanks
Josh