Qliksense - New Column Values Based on Existing Column Values separated by Comma

QlikEnth — Sat, 16 Nov 2024 02:33:48 GMT

Hello Experts,

I want to achieve the below for a Data Load Scenario:

Example: I have 5 Columns (ID, Column 1, Column 2, Column 3, Column4 ) i need to create a new Column based on the Four Columns (Column 1, Column 2, Column 3, Column4 ). If there is any data available in that 4 columns, then the new column should have the Data from the 4 columns seperated by comma, if theres no data available in 4 columns then the New column should display as Blank. (See Below for Example Scenario).

Appreciate our help: Example Table Scenario:

ID	Column1	Column2	Column3	Column	Output New Column
1	A		C		A,C
2	A	B	C	D	A,B,C,D
3		D	C		D,C
4					EMPTY
5	A	B		D	A,B,D

Thanks.

topic Qliksense - New Column Values Based on Existing Column Values separated by Comma in App Development

Qliksense - New Column Values Based on Existing Column Values separated by Comma