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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
n_elsman
Contributor
Contributor

Substring of Variable in Listbox

So, I have a variable: vString

This string contains the following data: "01-02-03-04-05-06"

I want to have each seperate value displayed in a Listbox without reloading the dashboard

I have tried to use substring and ListView but they did not give me the result that i want.

The endresult should be that the listbox has the following values

LB1:

01

02

03

04

05

06

Does anybody know how to do this?

I know i could do it in the script but i want/need to have it in the dashboard itself without the reload

Thanks in advance

3 Replies
vishsaggi
Champion III
Champion III

Why exactly you need this in expr? How the selections in your LB will effect your data? Can you tell us what exactly you are trying to achieve?

marcel_olmo
Partner Ambassador
Partner Ambassador

Hello Nard,

as you said, with the following in the script:

SubField('$(vString)','-')

it will do what you want.

Could you share with us more details of the case, to understand why you can't do it this way?

Regards, Marcel

MarcoWedel

Hi,

one way to create such a listbox might be:

QlikCommunity_Thread_317385_Pic1.JPG

QlikCommunity_Thread_317385_Pic2.JPG

=ValueList('$(=Replace(vString,'-',Chr(39)&','&Chr(39)))')

QlikCommunity_Thread_317385_Pic3.JPG

but I guess the more interesting question is, how you expect this listbox to behave.

hope this helps

regards

Marco