header row in straight table

[#1]

Hi Team,

I need to add header row in straight table something like this,

Column 1		Column 2
sub column 1	sub column 2	sub column 3	sub column 2	sub column 3

kindly provide solution asap.

Thanks in advance.

regards,

Rasool

[sunny_talwar]

Why don't you use pivot table instead?

[Peter_Cammaert]

As Sunny already mentioned, the solution is to use a Pivot Table.

QlikView Straight Tables don't support hierarchical headers.

[#4]

hi sunny ,

thanks for ur reply, But I need to show Total of those columns in last row.

[sunny_talwar]

You should be able to do that in pivot table (although with some brute force )

[Peter_Cammaert]

So?

For a pivot table to display totals, use Subtotals in the Presentation tab.

[#7]

It will give me total for all the subcolumn in the table....But my requirement is something like i need Total for particular sub column for example sub column 2 in Column 1 and sub column 3 in Colunm  2.

[sunny_talwar]

Like I said, with some brute force, anything is possible in a pivot table

[#9]

can u share it viva test qvw???

[sunny_talwar]

It might be easier if you can share some sample data and the exact output you need from it