Need to merge 2 rows for few columns only for same values in qlik sense cloud native object straight table

[Shiva_65481241]

I wanted to merge 2 rows in a straight table only for few columns for particular periodic months only after that there should be the 2 different rows. Please seethe below screen shot for the o/p i am looking for.

Qlik Sense Business Qlik Cloud 

@sunny_talwar 

[Qrishna]

In a straight table this is not possible. try using pivot table.

[Shiva_65481241]

Thank you @Qrishna for your response, but the requirement is straight table only. May I know how we can make it in pivot table also.

[seanbruton]

Hi, 

In your data model normalize the two rows column with an alias, then replace the dimension with the new normalized fields. This will work. Please note that any dimension field shown on straight table will create a new line. You will also get null values in the table untick include null values

[Kushal_Chawda]

@Shiva_65481241  How your merged values in the dimension should look like?

[Shiva_65481241]

Hello @seanbruton Thanks for the response but the dimensions are dynamic for the month and year period, how we can make it in backend with the normalization technique. could you please advise for the same, Thank you! 

FYI- till sept-2024 only they want 1 merged row because till sep-2024 that station was single only but from new year it has been separated so afterwards they will, have 2 rows with 2 values. and month period column is dynamically calculated, but till sept 2024 we can hardcode the values for that 2 stations.

See the snapshot below how straight table will look like.

[seanbruton]

Hi,

Here is an example:

Col_A ; Col_B ; Col_C

CCN News; 2024; 03

Use:

Col_A &'|'& Col_B &'|'& Col_C as Key_1

The data will look like; CCN News|2024|03

To show or extract the data you can use subfields or replace functions.

I hope this helps.

[Shiva_65481241]

Thanks @seanbruton but This won't help, I gave you above the scenario and yours Solution is not working there for me.

[Shiva_65481241]

Hello @Kushal_Chawda , this snapshot i have taken from excel which user shared with us as a requirement that is not a Qlik straight table. I hope this is what u have asked me?

[Kushal_Chawda]

@Shiva_65481241  But I don't understand which cell needs to be merged here