topic Re: Linking 2 states in QlikView https://community.qlik.com/t5/QlikView/Linking-2-states/m-p/449385#M558040 <HTML><HEAD></HEAD><BODY><P>How do i link 2 states in the expression?</P><P>example something like "Sum({Main}{Sub1}[Price])"</P></BODY></HTML> Fri, 07 Jun 2013 04:16:53 GMT 2013-06-07T04:16:53Z Linking 2 states https://community.qlik.com/t5/QlikView/Linking-2-states/m-p/449384#M558039 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have created the following:</P><P>- 3 states (Main, Sub1 and Sub2)</P><P>- 2 charts</P><P>- Input data (ProductStatus, Price and Region)</P><P></P><P>Let's say ChartA displaying ProductStatus ('Cancelled','Expired') and ChartB displaying ProductStatus ('Available').</P><P>In my chart expression i'm using "Sum({Sub1}[Price])" for ChartA and "Sum({Sub2}[Price])" for ChartB.</P><P></P><P>My question is how do i change the 2 charts' value if i change the region in Main state?</P><P></P><P>* Sorry for my bad explaination </P></BODY></HTML> Fri, 07 Jun 2013 04:14:52 GMT https://community.qlik.com/t5/QlikView/Linking-2-states/m-p/449384#M558039 2013-06-07T04:14:52Z Re: Linking 2 states https://community.qlik.com/t5/QlikView/Linking-2-states/m-p/449385#M558040 <HTML><HEAD></HEAD><BODY><P>How do i link 2 states in the expression?</P><P>example something like "Sum({Main}{Sub1}[Price])"</P></BODY></HTML> Fri, 07 Jun 2013 04:16:53 GMT https://community.qlik.com/t5/QlikView/Linking-2-states/m-p/449385#M558040 2013-06-07T04:16:53Z Re: Linking 2 states https://community.qlik.com/t5/QlikView/Linking-2-states/m-p/449386#M558041 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: 'courier new', courier; background-color: #ffffff;">Sum({Sub1&lt;Region = $::Region&gt;}[Price])</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">See the "What's new in QV 11" in your getting started page for a working example.</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">-Rob</SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"><A class="jive-link-external-small" href="http://robwunderlich.com">http://robwunderlich.com</A></SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"><A class="jive-link-external-small" href="http://masterssummit.com">http://masterssummit.com</A><BR /></SPAN></P></BODY></HTML> Fri, 07 Jun 2013 04:27:46 GMT https://community.qlik.com/t5/QlikView/Linking-2-states/m-p/449386#M558041 rwunderlich 2013-06-07T04:27:46Z Re: Linking 2 states https://community.qlik.com/t5/QlikView/Linking-2-states/m-p/449387#M558042 <HTML><HEAD></HEAD><BODY><P>thank you.</P></BODY></HTML> Fri, 07 Jun 2013 05:13:38 GMT https://community.qlik.com/t5/QlikView/Linking-2-states/m-p/449387#M558042 2013-06-07T05:13:38Z