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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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,',')