Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

selection list from string

hello

1.

I would like to know if it's possible to load a selection list with values that I have in a string.  for example we have

SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';

and I would like to have in my selection list box values :lun. ,mar.,....

2. how can i link this day with a field that I have in a table? via a join? so absolutely need to create an INLINE object with those daynames first?

thks

Valery

1 Reply
swuehl
MVP
MVP

Your DayNames is just a string variable, so you can't select values from that.

But you can create a field from your variable like:

SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';

DayName:

LOAD subfield('$(DayNames)',';') as Dayname

AutoGenerate 1;