In qliksense creating a multiple rows in one column in a Table
Hello,
In Qliksense I need to show a Table that will have data like.. There will be 3 columns in a table... 1st column will have One id but in 2nd column we will get 3 ids in 3 rows ( it may grow to n rows also..) corresponding to 1st column.. Same like 3 rd column also... It will refer 1st column.. These 3 columns are like 1 set.. Not getting how to create that type of rows....
Maybe using string agg & case like...
Max(Case when Id=1 then ID), String_Agg((Case when Id=1 then ABC), '|'), String_Agg((Cass when id =1 then BCD),' |'), Like these...
no idea syntax for that in qliksense....... **Attached a sample one how the rows should be...**
