topic In qliksense creating a multiple rows in one column in a Table in App Development

In qliksense creating a multiple rows in one column in a Table

chinni — Mon, 09 May 2022 08:25:26 GMT

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...**

Anyone help plss...

Thanks in advance..!!

Re: In qliksense creating a multiple rows in one column in a Table

abhijitnalekar — Mon, 09 May 2022 10:27:10 GMT

Hi @chinni ,

Is it fine if we show all 3 values from the 2nd column in one row with a comma seperator?

Re: In qliksense creating a multiple rows in one column in a Table

chinni — Mon, 09 May 2022 11:04:40 GMT

No Abhijit..

It should be same like that..I have attached one sample file..

The 3 rows should be there in 1 column..