Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

How merge several fields of flags into 1 field

On the main table transaction (which has over 100 million records) I have 10 flag fields with the value 0 or 1 ([field1_flag], [field2_flag], ..., [field10_flag]). I want to change all flag fields to 1 flag field type of binary (maybe string)  (eg: [all_fields_flag]) with values like: 000010001. I want take value from field [all_fields_flag] eg: 5 character and multiply with another field of transaction field. Do You have example about this? Thanks in advance.

Labels (2)
1 Reply
Partner - Creator III
Partner - Creator III

Please try:

[field1_flag]&[field2_flag]&[field3_flag]&[field4_flag] etc.

will give you the string wanted '0010101010'

So you are just concatenating the fields with '&' character