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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Combining multiple fields into one


Hello Everybody.

I have an issue.

Suppose I have 3 fields

Category 1

Category 2

Category 3.

Now I want to cretae a list box as Category where all these three category values reside.

I know I can easily do it at script level by concatenating all these fields, but in real scenario I have many fields of this type , and by this way I would be creating many synthetic keys.

Therefore I want to achieve it at front level only..

Any Ideas,,,,,,,,,,,

Regards

Nitin

10 Replies
sivarajs
Specialist II
Specialist II

SubField(category1&','&category3&','&category3,',') as newField

This can be used in script as well in list box expression (SubField(category1&','&category3&','&category3,',')