Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ericheleine
Contributor III
Contributor III

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
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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!

View solution in original post

4 Replies
awhitfield
Partner - Champion
Partner - Champion

Hi Eric,

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

Andy

ericheleine
Contributor III
Contributor III
Author

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.

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Contributor III
Contributor III
Author

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