Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Merge and split header in straight table

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

Capture1.PNG

I'm trying to obtain the as shown below

Capture2.PNG

Thank you in advance community.

7 Replies

Use calculated dimensions

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

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

Can you share application?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable

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

Not sure I understand...

Not applicable

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. 

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

Contributor II
Contributor II

hi Naveen,

Did you  solve this problem ?