topic Alternate state in calculated dimension - Set analysis in QlikView https://community.qlik.com/t5/QlikView/Alternate-state-in-calculated-dimension-Set-analysis/m-p/621388#M681549 <HTML><HEAD></HEAD><BODY><P>Guys,</P><P></P><P>I have two alternate states, one is &lt;inherited&gt; the other one is &lt;Healthy_Food_State&gt;...</P><P></P><P>I have one chart table that it is in the inherited stated, but I want one dimension to be in get the possible selections in the Healthy_Food_State, and then they match...</P><P></P><P>Can you guys say to me a possible expression?</P><P></P><P>I am trying something like:</P><P></P><P>=only({$&lt;item_substitute= ::[Healthy_Food_State]&gt;}item_substitute)</P><P></P><P>I do suck at those kind of expressions.</P><P></P><P>Can you guys tell me a possible solution for that?</P></BODY></HTML> Wed, 09 Apr 2014 23:14:51 GMT 2014-04-09T23:14:51Z Alternate state in calculated dimension - Set analysis https://community.qlik.com/t5/QlikView/Alternate-state-in-calculated-dimension-Set-analysis/m-p/621388#M681549 <HTML><HEAD></HEAD><BODY><P>Guys,</P><P></P><P>I have two alternate states, one is &lt;inherited&gt; the other one is &lt;Healthy_Food_State&gt;...</P><P></P><P>I have one chart table that it is in the inherited stated, but I want one dimension to be in get the possible selections in the Healthy_Food_State, and then they match...</P><P></P><P>Can you guys say to me a possible expression?</P><P></P><P>I am trying something like:</P><P></P><P>=only({$&lt;item_substitute= ::[Healthy_Food_State]&gt;}item_substitute)</P><P></P><P>I do suck at those kind of expressions.</P><P></P><P>Can you guys tell me a possible solution for that?</P></BODY></HTML> Wed, 09 Apr 2014 23:14:51 GMT https://community.qlik.com/t5/QlikView/Alternate-state-in-calculated-dimension-Set-analysis/m-p/621388#M681549 2014-04-09T23:14:51Z Re: Alternate state in calculated dimension - Set analysis https://community.qlik.com/t5/QlikView/Alternate-state-in-calculated-dimension-Set-analysis/m-p/621389#M681550 <HTML><HEAD></HEAD><BODY><P>=only({$&lt;item_substitute={Healthy_Food_State}::item_substitute&gt;}item_substitute)</P></BODY></HTML> Wed, 09 Apr 2014 23:20:37 GMT https://community.qlik.com/t5/QlikView/Alternate-state-in-calculated-dimension-Set-analysis/m-p/621389#M681550 2014-04-09T23:20:37Z Re: Re: Alternate state in calculated dimension - Set analysis https://community.qlik.com/t5/QlikView/Alternate-state-in-calculated-dimension-Set-analysis/m-p/621390#M681551 <HTML><HEAD></HEAD><BODY><P>it didn't work, try to see here the attachment:</P><P></P><P>in the third blue box we have the chart called "Saving"... The calculated dimension is in there. I want to get the item_id from the other state, (i want the item_id as in the second blue box, in the blue chart called "Food Price").</P></BODY></HTML> Wed, 09 Apr 2014 23:32:12 GMT https://community.qlik.com/t5/QlikView/Alternate-state-in-calculated-dimension-Set-analysis/m-p/621390#M681551 2014-04-09T23:32:12Z Re: Re: Re: Alternate state in calculated dimension - Set analysis https://community.qlik.com/t5/QlikView/Alternate-state-in-calculated-dimension-Set-analysis/m-p/621391#M681552 <HTML><HEAD></HEAD><BODY><P>PFA</P><P></P><P><BR /> </P></BODY></HTML> Thu, 10 Apr 2014 02:23:56 GMT https://community.qlik.com/t5/QlikView/Alternate-state-in-calculated-dimension-Set-analysis/m-p/621391#M681552 2014-04-10T02:23:56Z