https://community.qlik.com/t5/QlikView/Using-alternate-state-in-condition-for-a-calculated-dimension/m-p/1794990#M1211101 <P>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.&nbsp;</P><P>&nbsp;</P><P>Thank you in advance for your help!</P> Sat, 27 Mar 2021 07:07:37 GMT zwilson_borg 2021-03-27T07:07:37Z https://community.qlik.com/t5/QlikView/Using-alternate-state-in-condition-for-a-calculated-dimension/m-p/1794990#M1211101 <P>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.&nbsp;</P><P>&nbsp;</P><P>Thank you in advance for your help!</P> Sat, 27 Mar 2021 07:07:37 GMT https://community.qlik.com/t5/QlikView/Using-alternate-state-in-condition-for-a-calculated-dimension/m-p/1794990#M1211101 zwilson_borg 2021-03-27T07:07:37Z https://community.qlik.com/t5/QlikView/Using-alternate-state-in-condition-for-a-calculated-dimension/m-p/1795021#M1211102 <P>Use the&nbsp;<A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/StringAggregationFunctions/concat.htm" target="_self">Concat</A>&nbsp;function, it will return a string of selections from the Hierarchy dimension.</P><P>if (Concat({AlternateStateName}[Hierarchy]) = 'Division',[Division],[Unit])</P><P>&nbsp;</P> Sat, 27 Mar 2021 12:06:58 GMT https://community.qlik.com/t5/QlikView/Using-alternate-state-in-condition-for-a-calculated-dimension/m-p/1795021#M1211102 jwjackso 2021-03-27T12:06:58Z