topic Re: Using an expression result as a selection in QlikView https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065084#M523066 <HTML><HEAD></HEAD><BODY><P>What is the expression you are using right now?</P></BODY></HTML> Tue, 03 May 2016 13:25:22 GMT sunny_talwar 2016-05-03T13:25:22Z Using an expression result as a selection https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065080#M523062 <HTML><HEAD></HEAD><BODY><P>I have a simple straight table that has a dimension and an expression.</P><P></P><P>The expression either outputs yes or no.</P><P></P><P>However i cannot select the expression results to only show yes's or only show no's</P><P></P><P>can this be done?</P></BODY></HTML> Tue, 03 May 2016 13:15:49 GMT https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065080#M523062 matthewp 2016-05-03T13:15:49Z Re: Using an expression result as a selection https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065081#M523063 <HTML><HEAD></HEAD><BODY><P>May be like this, to show just yes</P><P></P><P><STRONG>If(Expression = 'Yes', Expression)</STRONG></P></BODY></HTML> Tue, 03 May 2016 13:16:58 GMT https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065081#M523063 sunny_talwar 2016-05-03T13:16:58Z Re: Using an expression result as a selection https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065082#M523064 <HTML><HEAD></HEAD><BODY><P>in the table or in the list box?</P></BODY></HTML> Tue, 03 May 2016 13:18:55 GMT https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065082#M523064 matthewp 2016-05-03T13:18:55Z Re: Using an expression result as a selection https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065083#M523065 <HTML><HEAD></HEAD><BODY><P>If you want to select the 'yes' or 'no' data.. you need to look on calculated dimension</P></BODY></HTML> Tue, 03 May 2016 13:20:41 GMT https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065083#M523065 settu_periasamy 2016-05-03T13:20:41Z Re: Using an expression result as a selection https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065084#M523066 <HTML><HEAD></HEAD><BODY><P>What is the expression you are using right now?</P></BODY></HTML> Tue, 03 May 2016 13:25:22 GMT https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065084#M523066 sunny_talwar 2016-05-03T13:25:22Z Re: Using an expression result as a selection https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065085#M523067 <HTML><HEAD></HEAD><BODY><P>Hi, matthewp.</P><P></P><P>See if the solution in Thread the help - <A href="https://community.qlik.com/message/1031169">Re: Searching with Set Analysis</A>.</P><P></P><P>Otherwise, an idea would be use expression in object ListBox.</P><P></P><P>Ex.:</P><P></P><P><STRONG>Aggr(Sum(expression),dimension).</STRONG></P><P><STRONG><BR /></STRONG></P><P>Hope this helps!</P></BODY></HTML> Tue, 03 May 2016 13:25:50 GMT https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065085#M523067 jonas_rezende 2016-05-03T13:25:50Z Re: Using an expression result as a selection https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065086#M523068 <HTML><HEAD></HEAD><BODY><P>Try within a listbox:</P><P></P><P>aggr(YourExpression, YourDimension)</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 03 May 2016 13:27:57 GMT https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065086#M523068 marcus_sommer 2016-05-03T13:27:57Z Re: Using an expression result as a selection https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065087#M523069 <HTML><HEAD></HEAD><BODY><P>=IF(Numb-Above(<SPAN style="font-size: 13.3333px;">Numb</SPAN>) = 1 ),'Match','Check')</P></BODY></HTML> Tue, 03 May 2016 13:28:50 GMT https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065087#M523069 matthewp 2016-05-03T13:28:50Z Re: Using an expression result as a selection https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065088#M523070 <HTML><HEAD></HEAD><BODY><P>Try creating a list box using this expression:</P><P></P><P><STRONG>Aggr(If(Only({1}Numb) - Above(Only({1}Numb)) = 1, 'Match', 'Check'), </STRONG>DimensionsFromYourTableHere<STRONG>)</STRONG></P></BODY></HTML> Tue, 03 May 2016 13:34:24 GMT https://community.qlik.com/t5/QlikView/Using-an-expression-result-as-a-selection/m-p/1065088#M523070 sunny_talwar 2016-05-03T13:34:24Z