topic Re: If statement in chart expression in QlikView https://community.qlik.com/t5/QlikView/If-statement-in-chart-expression/m-p/1403076#M425114 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P>= Pick(Match(status, 1, 2), 'Given', 'Refused')</P></BODY></HTML> Tue, 12 Sep 2017 20:36:09 GMT vishsaggi 2017-09-12T20:36:09Z If statement in chart expression https://community.qlik.com/t5/QlikView/If-statement-in-chart-expression/m-p/1403075#M425113 <HTML><HEAD></HEAD><BODY><P>I and looking to create a if statement in a chart expressio. For example</P><P>if status = 1 then given </P><P>if status =2 then refused. </P><P></P><P>I Am trying to find a way to make this all one statement. </P></BODY></HTML> Tue, 12 Sep 2017 20:29:48 GMT https://community.qlik.com/t5/QlikView/If-statement-in-chart-expression/m-p/1403075#M425113 cjett7769 2017-09-12T20:29:48Z Re: If statement in chart expression https://community.qlik.com/t5/QlikView/If-statement-in-chart-expression/m-p/1403076#M425114 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P>= Pick(Match(status, 1, 2), 'Given', 'Refused')</P></BODY></HTML> Tue, 12 Sep 2017 20:36:09 GMT https://community.qlik.com/t5/QlikView/If-statement-in-chart-expression/m-p/1403076#M425114 vishsaggi 2017-09-12T20:36:09Z Re: If statement in chart expression https://community.qlik.com/t5/QlikView/If-statement-in-chart-expression/m-p/1403077#M425115 <HTML><HEAD></HEAD><BODY><P>This should be enough</P><P></P><P><STRONG>Pick(status, 'Given', 'Refused')</STRONG></P><P></P><P>Because match will also assign 1, 2 value to status which is its value already <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 12 Sep 2017 20:55:49 GMT https://community.qlik.com/t5/QlikView/If-statement-in-chart-expression/m-p/1403077#M425115 sunny_talwar 2017-09-12T20:55:49Z Re: If statement in chart expression https://community.qlik.com/t5/QlikView/If-statement-in-chart-expression/m-p/1403078#M425116 <HTML><HEAD></HEAD><BODY><P>Yeah, you are right. Got it. </P></BODY></HTML> Tue, 12 Sep 2017 20:58:26 GMT https://community.qlik.com/t5/QlikView/If-statement-in-chart-expression/m-p/1403078#M425116 vishsaggi 2017-09-12T20:58:26Z