I need to add header row in straight table something like this,
kindly provide solution asap.
Thanks in advance.
Why don't you use pivot table instead?
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 )
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
YTD Target , YTD Actual... these colunms are caluculated at front end.
I am asking you to provide me with the raw data so that i can recreate these charts my friend
Pls consider the "current output" in given attachment as raw data.
Since it will take me sometime to transform the data in current output tab, I will either let someone else help or if nobody helps, I will try to work on this over the weekend
Hi Sunny Talwar
pfa of raw data for my query
For a pivot table to display totals, use Subtotals in the Presentation tab.
As Sunny already mentioned, the solution is to use a Pivot Table.
QlikView Straight Tables don't support hierarchical headers.
Retrieving data ...