Calculated Dimension from different Dimensions?

Tue, 11 Jun 2013 14:59:26 GMT

Hello,

I want to create a calculated dimension which consists fields from different other dimensions:

if(Account_Group_GRLaR = 'GRLactRet','GRLactRet',

if(Account_Group_GRLR = 'GRLtotRet','GRLtotRet',

if(Account_Group_IncbefIC = 'WHVINET','WHVINET',

if(Account_Group_IncbefTax = 'WHVIIBTX','WHVIIBTX',

if(Account_Group_IncIncIC = 'WHVINETIC','WHVINETIC',

if(Account_Group_NetContr = 'WHVINETC','WHVINETC',

if(Account_Group_NetRev = 'WHVCORE','WHVCORE',

if(Account_Group_NetRev = 'WHVIHVNR','WHVIHVNR',

if(Account_Group_OpInc = 'WHVIOPTI','WHVIOPTI',

if(Account_Group_TotRet = 'WHVITOTRTN','WHVITOTRTN',

if(Account_Group_TotRev = 'WHVITREV','WHVITREV',

if(Account_Group_VarContr = 'WHVIVCON','WHVIVCON',

if(Account_Group_VarContr = 'WHVIFIXX','WHVIFIXX',

Null())))))))))))))

I want to use this dimension in a Listbox as a field <Expression>.

My problem at the moment is, that the result looks like this:

a dimension with only 4 members: WHVINET, GRLactRet, WHVINETIC, GRLtotRet.

Do anybody know why I do not see the rest of the calculated dimension?

Regards

Steven

topic Calculated Dimension from different Dimensions? in QlikView