Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

ericheleine
New Contributor

create a new dimension

hi everyone,

I have got severale dimensions:
Factor1

Factor2

Factor3

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

regards

Eric

1 Solution

Accepted Solutions

Re: create a new dimension

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!

4 Replies
awhitfield
Esteemed Contributor

Re: create a new dimension

Hi Eric,

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

Andy

ericheleine
New Contributor

Re: create a new dimension

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

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!

ericheleine
New Contributor

Re: create a new dimension

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

Community Browser