Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
ivanbrewer
Contributor
Contributor

Creating Valuelist from a field syntaxis

Hi All,

This forum is incredible, thank you all for this being such a great place. Now I am a bit pressured in time and stuck:

I have a field "vl_pl_lines_names" with the PL names, say 'Sales', 'Costs', 'Profit' (however it is many lines (~30), so I want to handle it via excel load as a field, I also have other reasons for that). I want to create a valuelist dimension from this field. I do the following:

0/ Load the field itself

1/ Create a variable v_vl_pl_lines_names:

"=chr(39)&Concat(vl_pl_lines_names,chr(39)&chr(44)&chr(39),vl_pl_lines_rank)&chr(39)"

2/ Create a valuelist dimension in the table as simple as 

=ValueList(v_vl_pl_lines_names)

Instead of creating a table with all the PL names as lines, it creates a table with all the PL names sitting in the first row - what do i do wrong?

clipboard_image_0.png

clipboard_image_1.png

clipboard_image_3.png

Thank you,

Kind regards,

Ivan

 

Labels (2)
1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

You may try it with: =ValueList($(v_vl_pl_lines_names))

But IMO it's much too complicated  - you could just load this field (or maybe multiple, for example further groupings) as an unlinked table which means no extra efforts with such a variable creation/calling and further it's much easier to handle within the object and/or as selection as a valuelist().

- Marcus