topic Substring of Variable in Listbox in QlikView

Substring of Variable in Listbox

n_elsman — Fri, 19 Oct 2018 13:10:29 GMT

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:

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

vishsaggi — Fri, 19 Oct 2018 17:26:18 GMT

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 — Fri, 19 Oct 2018 18:30:32 GMT

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 — Fri, 19 Oct 2018 23:38:11 GMT

Hi,

one way to create such a listbox might be:

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

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

hope this helps

regards

Marco