topic Re: Table Header Formatting and Grouping in QlikView

Table Header Formatting and Grouping

Fri, 07 Aug 2015 10:27:11 GMT

Dear Expert/Team,

Is there is any way to get below type of group columns header in table(Straight Table).

Re: Table Header Formatting and Grouping

kuczynska — Fri, 07 Aug 2015 10:37:20 GMT

How is your data constructed? Are you loading your data from a crosstable? Can you send a sample data?

Re: Table Header Formatting and Grouping

Fri, 07 Aug 2015 10:44:02 GMT

Turnover, Trades and Ratio all are different fields and Columns, Its just represent aspect how u show it just decorative part.

Re: Table Header Formatting and Grouping

Fri, 07 Aug 2015 10:49:24 GMT

Original is the same as we see in Qlikview Table,

But i want to decorate it so can be more understandable. So if we add some other more Columns its visible Clear.

Re: Table Header Formatting and Grouping

Kushal_Chawda — Fri, 07 Aug 2015 10:56:34 GMT

Please see the attached

Re: Table Header Formatting and Grouping

Fri, 07 Aug 2015 11:10:27 GMT

Hi,

Appreciate you reply, but what ia have share is just sample of output actual data have lots of Dimension and Expression.

and the group the Columns is also not have any specific fix rules.

Above is actual table but still my main load table have many more columns than this and also all information is not in one table only its relation data Model . here each expression have some specific type of Set Analysis like: few Cloumns show Total and few Columns show Weekly and few Columns show Weekly also some more set analysis associated to this. so when i have to of Columns i required to group cloumns by giving a extra Header name (as shown in example) to its can be more understandable and visible.

That also help me in reducing repeating text in each Columns again and again.

Re: Table Header Formatting and Grouping

Kushal_Chawda — Fri, 07 Aug 2015 11:30:18 GMT

If you want to achieve this, you have to use pivot table. I think you are using straight table.

If you have pivot table with many expression you just need to create the dummy dimension and drag over expressions, so it will group all the expression

Hope it's clear

Re: Table Header Formatting and Grouping

Fri, 07 Aug 2015 11:37:54 GMT

You idea is good, but in Pivot table we did not get freedom of sorting by double clicking on columns and many more.

Re: Table Header Formatting and Grouping

Kushal_Chawda — Fri, 07 Aug 2015 11:48:43 GMT

May be some experts can advice

Re: Table Header Formatting and Grouping

Fri, 07 Aug 2015 11:51:46 GMT

For the time being i am trying to put background color in cell to Group. that will also help in getting better view

Re: Table Header Formatting and Grouping

Digvijay_Singh — Fri, 07 Aug 2015 11:56:43 GMT

Or for better readability you can stick some text boxes in the header with 'top' layer, 100% transparency options checked. Before that you can create extra spaces in header by wrapping the header text....just a workaround only...

Re: Table Header Formatting and Grouping

Fri, 07 Aug 2015 11:59:11 GMT

Nice Idea, But we share this information in excel or PDF format then its will not show in same format.