topic Ability to Group Colums in QlikView

Ability to Group Colums

hschultz — Mon, 03 Sep 2012 13:46:29 GMT

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

Re: Ability to Group Colums

Mon, 03 Sep 2012 13:48:23 GMT

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

Re: Ability to Group Colums

whiteline — Mon, 03 Sep 2012 14:55:53 GMT

There is no such functionality.

But there's plenty of ways of doing something similar

Re: Ability to Group Colums

chematos — Mon, 03 Sep 2012 15:01:41 GMT

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 )

Re: Ability to Group Colums

whiteline — Mon, 03 Sep 2012 15:08:04 GMT

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

He want to build a chart with groupped expresisons.

Re: Ability to Group Colums

hschultz — Tue, 04 Sep 2012 06:16:57 GMT

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.