topic Re: Merge and split header in straight table in QlikView

Merge and split header in straight table

Wed, 25 Nov 2020 16:16:04 GMT

I have straight table with two expressions for each month resulting in 24 expressions sample of resultant view is below

I'm trying to obtain the as shown below

Thank you in advance community.

Re: Merge and split header in straight table

sunny_talwar — Wed, 26 Jul 2017 15:52:06 GMT

Use calculated dimensions

1) SubField(Month, '-', 1)

2) SubField(Month, '-', 2)

Re: Merge and split header in straight table

Anil_Babu_Samineni — Wed, 26 Jul 2017 16:03:57 GMT

Can you share application?

Re: Merge and split header in straight table

Wed, 26 Jul 2017 16:09:19 GMT

Value1, Value2, Value2... is from one dimension. and there is two expression for each month

Re: Merge and split header in straight table

sunny_talwar — Wed, 26 Jul 2017 16:10:21 GMT

Not sure I understand...

Re: Merge and split header in straight table

Wed, 26 Jul 2017 16:17:00 GMT

Sorry about that Sunny. Let me try to make it clearer here. So I have a straight table where i have selected one field as a dimension and in expressions field i have 24 expressions. This produced a view like the first one in my post. Now I was trying to merge the Label as shown in the second image.

Re: Merge and split header in straight table

sunny_talwar — Wed, 26 Jul 2017 16:28:55 GMT

Not sure how your data looks like, but you should be able to get the above view using pivot table with 2 or 3 dimensions. You might need to get in synthetic dimensions, but it would be difficult to say much without seeing the raw data

Re: Merge and split header in straight table

Anonymous — Fri, 23 Feb 2018 04:25:17 GMT

hi Naveen，

Did you solve this problem ？