topic logic in QlikView https://community.qlik.com/t5/QlikView/logic/m-p/1442717#M810145 <HTML><HEAD></HEAD><BODY><P>In the dimension i have to consider a Filed called IDNumber...</P><P></P><P></P><P>Iam writing the below expression </P><P></P><P></P><P>If(Status'Active'IDNumber)</P><P></P><P></P><P></P><P></P><P>Where ever the status is Active i want to display only those IDNUmber's </P><P></P><P></P><P></P><P></P><P>Is the above expression in the Dimension is correct </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT smilingjohn 2020-11-25T16:16:04Z logic https://community.qlik.com/t5/QlikView/logic/m-p/1442717#M810145 <HTML><HEAD></HEAD><BODY><P>In the dimension i have to consider a Filed called IDNumber...</P><P></P><P></P><P>Iam writing the below expression </P><P></P><P></P><P>If(Status'Active'IDNumber)</P><P></P><P></P><P></P><P></P><P>Where ever the status is Active i want to display only those IDNUmber's </P><P></P><P></P><P></P><P></P><P>Is the above expression in the Dimension is correct </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/logic/m-p/1442717#M810145 smilingjohn 2020-11-25T16:16:04Z Re: logic https://community.qlik.com/t5/QlikView/logic/m-p/1442718#M810146 <HTML><HEAD></HEAD><BODY><P>May be these?</P><P><STRONG>If(Match(Status,'Active'),IDNumber)</STRONG></P><P><STRONG>OR</STRONG></P><P><STRONG>If(Status Like 'Active', IDNumber)</STRONG></P></BODY></HTML> Thu, 12 Oct 2017 11:40:27 GMT https://community.qlik.com/t5/QlikView/logic/m-p/1442718#M810146 Anil_Babu_Samineni 2017-10-12T11:40:27Z Re: logic https://community.qlik.com/t5/QlikView/logic/m-p/1442719#M810147 <HTML><HEAD></HEAD><BODY><P>You can also do this</P><P></P><P><STRONG>If(Status = 'Active', IDNumber)</STRONG></P><P></P><P>and then make sure to check 'Suppress When Value Is Null' on the dimension tab of the chart properties</P></BODY></HTML> Thu, 12 Oct 2017 11:43:01 GMT https://community.qlik.com/t5/QlikView/logic/m-p/1442719#M810147 sunny_talwar 2017-10-12T11:43:01Z Re: logic https://community.qlik.com/t5/QlikView/logic/m-p/1442720#M810148 <HTML><HEAD></HEAD><BODY><P>I think you may also try using the condition in your expression instead of Dimension as another approach.</P><P>=sum({&lt; Status={'Active'}&nbsp;&nbsp; &gt;}OrderID)</P></BODY></HTML> Thu, 12 Oct 2017 12:24:02 GMT https://community.qlik.com/t5/QlikView/logic/m-p/1442720#M810148 sudeepkm 2017-10-12T12:24:02Z