Multiple stacked dimensions

[#1]

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

G

[erichshiino]

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 ?

[#3]

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

[erichshiino]

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

[johnw · Accepted solution]

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.

[#6]

Thanks John