https://community.qlik.com/t5/App-Development/How-merge-several-fields-of-flags-into-1-field/m-p/1666491#M50190 <P><SPAN>Please try:</SPAN></P><P><SPAN>[field1_flag]&amp;[field2_flag]&amp;[field3_flag]&amp;[field4_flag] etc.</SPAN></P><P><SPAN>will give you the string wanted '0010101010'</SPAN></P><P><SPAN>So you are just concatenating the fields with '&amp;' character</SPAN></P> Thu, 16 Jan 2020 21:47:46 GMT jochem_zw 2020-01-16T21:47:46Z https://community.qlik.com/t5/App-Development/How-merge-several-fields-of-flags-into-1-field/m-p/1665055#M50033 <P>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) &nbsp;(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.</P> Sat, 16 Nov 2024 03:36:21 GMT https://community.qlik.com/t5/App-Development/How-merge-several-fields-of-flags-into-1-field/m-p/1665055#M50033 ViliuSas 2024-11-16T03:36:21Z https://community.qlik.com/t5/App-Development/How-merge-several-fields-of-flags-into-1-field/m-p/1666491#M50190 <P><SPAN>Please try:</SPAN></P><P><SPAN>[field1_flag]&amp;[field2_flag]&amp;[field3_flag]&amp;[field4_flag] etc.</SPAN></P><P><SPAN>will give you the string wanted '0010101010'</SPAN></P><P><SPAN>So you are just concatenating the fields with '&amp;' character</SPAN></P> Thu, 16 Jan 2020 21:47:46 GMT https://community.qlik.com/t5/App-Development/How-merge-several-fields-of-flags-into-1-field/m-p/1666491#M50190 jochem_zw 2020-01-16T21:47:46Z