topic Re: header row in straight table in QlikView

header row in straight table

Fri, 18 Aug 2017 11:29:01 GMT

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

Re: header row in straight table

sunny_talwar — Fri, 18 Aug 2017 11:32:48 GMT

Why don't you use pivot table instead?

Re: header row in straight table

Peter_Cammaert — Fri, 18 Aug 2017 11:37:44 GMT

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

QlikView Straight Tables don't support hierarchical headers.

Re: header row in straight table

Fri, 18 Aug 2017 11:41:39 GMT

hi sunny ,

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

Re: header row in straight table

sunny_talwar — Fri, 18 Aug 2017 11:43:03 GMT

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

Re: header row in straight table

Peter_Cammaert — Fri, 18 Aug 2017 11:43:12 GMT

So?

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

Re: header row in straight table

Fri, 18 Aug 2017 11:50:00 GMT

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.

Re: header row in straight table

sunny_talwar — Fri, 18 Aug 2017 11:51:52 GMT

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

Re: header row in straight table

Fri, 18 Aug 2017 11:55:25 GMT

can u share it viva test qvw???

Re: header row in straight table

sunny_talwar — Fri, 18 Aug 2017 11:56:15 GMT

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

Re: header row in straight table

Fri, 18 Aug 2017 12:06:08 GMT

pfa...

Re: header row in straight table

sunny_talwar — Fri, 18 Aug 2017 12:15:26 GMT

Raw data?

Re: header row in straight table

Fri, 18 Aug 2017 12:19:37 GMT

YTD Target , YTD Actual... these colunms are caluculated at front end.

Re: header row in straight table

sunny_talwar — Fri, 18 Aug 2017 12:29:22 GMT

I am asking you to provide me with the raw data so that i can recreate these charts my friend

Re: header row in straight table

Fri, 18 Aug 2017 12:42:53 GMT

Pls consider the "current output" in given attachment as raw data.

Re: header row in straight table

sunny_talwar — Fri, 18 Aug 2017 12:45:50 GMT

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

Re: header row in straight table

Mon, 21 Aug 2017 06:41:45 GMT

Hi Sunny Talwar

pfa of raw data for my query