Turning multiple data into a single field

[Fred-Zabala]

We have a with 12 different checkboxes. We want to make this column into a single field, and concatonate(spelling??) the results when there is more than 1 checkbox ticked

This is are the fields

SQL SELECT
F_Pm_Lease.PML_SEQ,
F_CusFieldLease_1.VALUE as [FTEs],
F_CusFieldLease_2.VALUE as [Cost Centre],
F_CusFieldLease_3.VALUE as [ Development Agreement],
F_CusFieldLease_4.VALUE as [Documentation Status],
F_CusFieldLease_5.VALUE as [Agreement to Lease],
F_CusFieldLease_6.VALUE as [Deed of Lease],
F_CusFieldLease_7.VALUE as [ Rent Review],
F_CusFieldLease_8.VALUE as [ Rent Review / Variation of Lease],
F_CusFieldLease_9.VALUE as [ Rent Review / Renewal of Lease],
F_CusFieldLease_10.VALUE as [Renewal of Lease],
F_CusFieldLease_11.VALUE as [ Renewal fo Lease / Variation of Lease],
F_CusFieldLease_12.VALUE as [Variation of Lease],

And we started doing it via match, but upon looking at the limitations, it would stop at the very first checkbox it finds. Is there another way to go around with when there are more than 1 checkbox ticked.

Thanks for your time and help

[chaorenzhu]

If I understand correctly you have 12 different columns and the value for each column is either checked or unchecked (1 or 0)? If that's the case and you want to turn the 12 columns into 1 column, try crosstable()

https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/LoadData/work-with-c...