topic Re: How to use selected item within an expression? in QlikView https://community.qlik.com/t5/QlikView/How-to-use-selected-item-within-an-expression/m-p/112848#M17525 <HTML><HEAD></HEAD><BODY><P>Hi Kelly,</P><P>You don't need to use a set expression here. A normal filter would work here. Also in set analysis RHS is supposed to be in curly brackets.</P><P></P><P>Regards,</P><P>Devyanshu</P></BODY></HTML> Fri, 24 Aug 2018 09:19:18 GMT devyanshu_gupta 2018-08-24T09:19:18Z How to use selected item within an expression? https://community.qlik.com/t5/QlikView/How-to-use-selected-item-within-an-expression/m-p/112847#M17524 <HTML><HEAD></HEAD><BODY><P>I want to use a selected item in my expression but I am not having any luck.. Here is the expression: </P><P><SPAN style="font-size: 13.3333px;">=count(DISTINCT{&lt;Capability_Level=GetFieldSelections(Capability_Level)&gt;} Capability_Number)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>The expression works if I hard code the Capability Level to equal a number but I want the users to be able to choose what Capability Level to look at.</P></BODY></HTML> Wed, 22 Aug 2018 16:45:01 GMT https://community.qlik.com/t5/QlikView/How-to-use-selected-item-within-an-expression/m-p/112847#M17524 Anonymous 2018-08-22T16:45:01Z Re: How to use selected item within an expression? https://community.qlik.com/t5/QlikView/How-to-use-selected-item-within-an-expression/m-p/112848#M17525 <HTML><HEAD></HEAD><BODY><P>Hi Kelly,</P><P>You don't need to use a set expression here. A normal filter would work here. Also in set analysis RHS is supposed to be in curly brackets.</P><P></P><P>Regards,</P><P>Devyanshu</P></BODY></HTML> Fri, 24 Aug 2018 09:19:18 GMT https://community.qlik.com/t5/QlikView/How-to-use-selected-item-within-an-expression/m-p/112848#M17525 devyanshu_gupta 2018-08-24T09:19:18Z Re: How to use selected item within an expression? https://community.qlik.com/t5/QlikView/How-to-use-selected-item-within-an-expression/m-p/112849#M17526 <HTML><HEAD></HEAD><BODY><P>=count(DISTINCT{&lt;Capability_Level={'$(=GetFieldSelections(Capability_Level))'}&gt;} Capability_Number)</P></BODY></HTML> Fri, 24 Aug 2018 09:37:22 GMT https://community.qlik.com/t5/QlikView/How-to-use-selected-item-within-an-expression/m-p/112849#M17526 BalaBhaskar_Qlik 2018-08-24T09:37:22Z