Discussion Board for collaboration related to Qlik Education.
I have got severale dimensions:Factor1
And i want to create a "master" dimension of those dimensions
Go to Solution.
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)
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...)
www.masterssummit.com - take your QlikView skills to the next level!
can you please expand your requirements, it's not clear what you are trying to achieve.
my factors are :
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.
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.