Ability to Group Colums

[hschultz]

Hi guys

Not sure if this is possible, but if i don't ask i guess i'll never know

I have a Straight Table chart with a few colums, but i want to know if i can put a heading or 2 over speciffic colums? So for instance it might look like this:

_______________________________________________________________________________________

                            |                         ACTUALS                     |                    BUDGET                            |                           

ITEM	SALES	QTY	SALES	QTY
123	1,200	12	1,000	10
124	2,400	16	3,000	20

I know that looks a bit weird, but it is the best way to describe it.

We would then like to color code the Actuals and Budgets colums.

I am sure i can build another table on top of it, taking out the caption of the bottom one, but i was wondering if there were this functionality easily inside QV.

Thank you for your responses

[#2]

I would suggest using a text box with a colored background, the only other way you could do it would be with inline tables but thats very messy

[whiteline]

There is no such functionality.

But there's plenty of ways of doing something similar

[chematos]

May be you can use a crosstable, take a look at the help menu in your QlikView

A cross table is a common type of table featuring a matrix of values between two orthogonal lists of header data. To turn a cross table into a straight table, use a crosstable prefix.

The syntax is:

crosstable (attribute field , data field [ , n ] ) ( loadstatement | selectstatement )

[whiteline]

I think he don't want to load this table.

He want to build a chart with groupped expresisons.

[hschultz]

That is exactly right whiteline.

Thanx for all your responses.

Was just wondering if there's a quick way, but i can build something around it.