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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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;