Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Why don't you use pivot table instead?
As Sunny already mentioned, the solution is to use a Pivot Table.
QlikView Straight Tables don't support hierarchical headers.
hi sunny ,
thanks for ur reply, But I need to show Total of those columns in last row.
You should be able to do that in pivot table (although with some brute force )
So?
For a pivot table to display totals, use Subtotals in the Presentation tab.
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.
Like I said, with some brute force, anything is possible in a pivot table
can u share it viva test qvw???
It might be easier if you can share some sample data and the exact output you need from it