Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated Dimension from different Dimensions?

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

0 Replies