topic Re: List Boxes - Get Selected Value Based on Another Selection in QlikView https://community.qlik.com/t5/QlikView/List-Boxes-Get-Selected-Value-Based-on-Another-Selection/m-p/215246#M68726 <HTML><HEAD></HEAD><BODY><P>Hi Paul, </P><P></P><P>Could you please share the solution!</P><P></P><P>Regards</P><P></P><P>Rahul </P></BODY></HTML> Tue, 07 Aug 2012 09:05:41 GMT 2012-08-07T09:05:41Z List Boxes - Get Selected Value Based on Another Selection https://community.qlik.com/t5/QlikView/List-Boxes-Get-Selected-Value-Based-on-Another-Selection/m-p/215243#M68723 <HTML><HEAD></HEAD><BODY><P>I have two list boxes on my screen nameley Product Family and Species.</P><P>We show Quantity and Sales value but only show the quantity if the selected values have the same quantity units.</P><P>I have this working okay for Product family.</P><P>Species values can fall into different Product Families e.g. Sapele could have an entry in either the Sawn or Machined Product Family with these having units of m3 and lineal metres respectively.</P><P>The user does not have to filter on a Product Family, they could go directly to the Species filter.</P><P>This is where my question comes in...</P><P>Based on the users Species selection, I want to go to the Product Family list box and determine how many Product Familes match the selection.</P><P>For example...</P><P>The species Idigbo (m3) only belongs to the Sawn Product family whilst the Sapele belongs to both Sawn (m2) and Machined (lineal metres).</P><P>If the user selects Idigbo I can show the quantity as it only has the unit m3 whilst the Sapele selection won't display a quantity as I have mixed units.</P><P>Any help greatly appreciated...</P><P></P><P></P></BODY></HTML> Tue, 06 Jul 2010 09:38:27 GMT https://community.qlik.com/t5/QlikView/List-Boxes-Get-Selected-Value-Based-on-Another-Selection/m-p/215243#M68723 pkelly 2010-07-06T09:38:27Z List Boxes - Get Selected Value Based on Another Selection https://community.qlik.com/t5/QlikView/List-Boxes-Get-Selected-Value-Based-on-Another-Selection/m-p/215244#M68724 <HTML><HEAD></HEAD><BODY><P>I think GetPossibleCount() may be the answer i.e. count the Quantity Unit.</P><P>Is it possible to do an if statement with GetPossibleCount...</P><P>I only want to count the Quantity Units if it is &lt;&gt; 'NONE' (within a Product Family there are some items for which we ignore the Qty)...</P><P>Have tried...</P><P>=GetPossibleCount(IF(pro_QuantityUnit&lt;&gt;'NONE', pro_QuantityUnit))</P><P>AND</P><P>=IF(pro_QuantityUnit&lt;&gt;'NONE', GetPossibleCount( pro_QuantityUnit))</P><P>Without sucess....</P><P></P><P></P></BODY></HTML> Tue, 06 Jul 2010 10:11:11 GMT https://community.qlik.com/t5/QlikView/List-Boxes-Get-Selected-Value-Based-on-Another-Selection/m-p/215244#M68724 pkelly 2010-07-06T10:11:11Z List Boxes - Get Selected Value Based on Another Selection https://community.qlik.com/t5/QlikView/List-Boxes-Get-Selected-Value-Based-on-Another-Selection/m-p/215245#M68725 <HTML><HEAD></HEAD><BODY><P>Managed to come up with a workaround....</P></BODY></HTML> Tue, 13 Jul 2010 07:50:20 GMT https://community.qlik.com/t5/QlikView/List-Boxes-Get-Selected-Value-Based-on-Another-Selection/m-p/215245#M68725 pkelly 2010-07-13T07:50:20Z Re: List Boxes - Get Selected Value Based on Another Selection https://community.qlik.com/t5/QlikView/List-Boxes-Get-Selected-Value-Based-on-Another-Selection/m-p/215246#M68726 <HTML><HEAD></HEAD><BODY><P>Hi Paul, </P><P></P><P>Could you please share the solution!</P><P></P><P>Regards</P><P></P><P>Rahul </P></BODY></HTML> Tue, 07 Aug 2012 09:05:41 GMT https://community.qlik.com/t5/QlikView/List-Boxes-Get-Selected-Value-Based-on-Another-Selection/m-p/215246#M68726 2012-08-07T09:05:41Z