Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everyone,
I have got severale dimensions:
Factor1
Factor2
Factor3
And i want to create a "master" dimension of those dimensions
regards
Eric
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!
Hi Eric,
can you please expand your requirements, it's not clear what you are trying to achieve.
Andy
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.
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!
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