topic Re: Merging cells only on the 2nd Dimension in a Straight table in QlikView

Merging cells only on the 2nd Dimension in a Straight table

sgarim41 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I Have a table as follows,

Name	Star	Rating
Hary	Gold	5
Travis	Gold	4
Ken	Gold	7
Ryan	Silver	9
Sam	Bronze	2

Now i want to merge the cells only in the Star column alone to look like this,

Is there any way this can be achieved even though the name field primary dimension is different?

Note:

I need the order of columns to remain the same since the Name column should drive the table.

Re: Merging cells only on the 2nd Dimension in a Straight table

juraj_misina — Mon, 05 Mar 2018 23:14:32 GMT

Hi Santosh,

I'm afraid this is not achievable in Qlik.

Juraj

Re: Merging cells only on the 2nd Dimension in a Straight table

vishsaggi — Tue, 06 Mar 2018 02:37:45 GMT

Any specific reason of not using Pivot table in this scenario?

Re: Merging cells only on the 2nd Dimension in a Straight table

sgarim41 — Tue, 06 Mar 2018 15:09:46 GMT

I have some custom formating which is not possible in Pivot tables. Is this possible in pivot? If so I could be able to evaluate this scenario if you can provide me the solution.

Re: Merging cells only on the 2nd Dimension in a Straight table

vishsaggi — Tue, 06 Mar 2018 15:52:09 GMT

‌wwhat is the formatting you are looking for? Can you give us an example.