Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Using alternate state in condition for a calculated dimension

I need to use an alternate state's value of a field in the if statement condition of a calculated dimension. I've tried using combinations of sum, aggr, and only and haven't had much success. The basic idea of what I'm trying to do is if([Hierachy]='Division', [Division],[Unit]) - however, the [Hierarchy] is selected in a different alternate state than what the chart is being created against. 


Thank you in advance for your help!

1 Reply
Specialist II
Specialist II

Use the Concat function, it will return a string of selections from the Hierarchy dimension.

if (Concat({AlternateStateName}[Hierarchy]) = 'Division',[Division],[Unit])