topic Re: create a new dimension in Qlik Learning Discussions

create a new dimension

ericheleine — Tue, 03 Mar 2015 09:38:56 GMT

hi everyone,

I have got severale dimensions:
Factor1

Factor2

Factor3

And i want to create a "master" dimension of those dimensions

regards

Eric

Re: create a new dimension

awhitfield — Tue, 03 Mar 2015 14:47:31 GMT

Hi Eric,

can you please expand your requirements, it's not clear what you are trying to achieve.

Andy

Re: create a new dimension

ericheleine — Tue, 03 Mar 2015 15:39:35 GMT

Hi Andrew,

my factors are :

*earning mom

*growth

*leverage .....

I have got for each INSTRUMENT NAME the different factors because a create a dimension for each factor but my goal is to have for each factor the INSTRUMENT NAME list.

Re: create a new dimension

Oleg_Troyansky — Tue, 03 Mar 2015 15:48:23 GMT

It looks like you want to reload this table using the CROSSTABLE load, and create a new field Factor that can store the individual factor values:

CROSSTABLE (Factor, FactorValue)

LOAD

RESIDENT

MyTable

In the resulting table, you will have 2 columns - [INSTRUMENT NAME] and Factor.

Is that what you were looking for? Your description was still quite vague, try to be more specific and possibly describe the desired result (chart, table, etc...)

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

Re: create a new dimension

ericheleine — Tue, 03 Mar 2015 16:07:24 GMT

hi oleg thank you for your help

the desired result is a to have a block chart where for each factor I have the [INSTRUMENT NAME] sort by amount traded.

eric