topic Re: Multiple stacked dimensions in QlikView

Multiple stacked dimensions

Fri, 01 Jul 2011 12:51:52 GMT

Hi Everyone,

I have a bunch of dimensions (variables) for demographics that I want to show all at the same time in a single straight table. i.e. I want age (and the age bands), gender (M,F) etc... all in one table with the expressions giving results down all of these dimensions.

Has anyone ever done this?

THanks

Multiple stacked dimensions

erichshiino — Fri, 01 Jul 2011 14:21:06 GMT

In a straight table you can have multiple dimensions and expressions.

but I guess you need something more specific.

Can you share a sample of the data you want to use and describe some of your analysis ?

Multiple stacked dimensions

Fri, 01 Jul 2011 14:30:56 GMT

Yes now I realise my explanation was not great.

Instead of having a column for Age, another column for Gender, etc....

I want a single dimension column with all of these variables stacked on top of each other and then expressions on the right:

Sales

18-25 £xx

25-34 £xx

35+ £xx

M £xx

F £xx

Blue £xx

Red £xx

Green £xx

Does that make more sense?

Thanks

Gareth

Multiple stacked dimensions

erichshiino — Fri, 01 Jul 2011 14:47:09 GMT

Hi,

If those variables are predefined, I think you should use value list to create this 'artificial' dimension.

Then, you would need a if statement on your expression

You can check an example on this thread:

http://community.qlik.com/message/122667#122667

Regards,

Erich

Re: Multiple stacked dimensions

johnw — Fri, 01 Jul 2011 23:48:18 GMT

This is easily handled in the data model with a crosstable load of a supplementary table:

Combined:
CROSSTABLE (Dimension,Value)
LOAD
ID
,Age
,Color
,Gender
RESIDENT Data
;

See attached.

Re: Multiple stacked dimensions

Mon, 04 Jul 2011 11:00:13 GMT

Thanks John