topic Re: Convert if to set analysis? in QlikView https://community.qlik.com/t5/QlikView/Convert-if-to-set-analysis/m-p/1249553#M871357 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you can use pick &amp; match for the same thing..</P><P></P><P>like this:&nbsp; pick(match(TOOL,'A','B','C'),'A1','B1','C1')</P></BODY></HTML> Tue, 15 Nov 2016 06:55:28 GMT sushil353 2016-11-15T06:55:28Z Convert if to set analysis? https://community.qlik.com/t5/QlikView/Convert-if-to-set-analysis/m-p/1249552#M871356 <HTML><HEAD></HEAD><BODY><P>how to convert if statement to set analysis?</P><P></P><P>My if condition statement is</P><P></P><P>IF(TOOL='A','A1',IF(TOOL='B','B1','C1'))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Convert-if-to-set-analysis/m-p/1249552#M871356 gireesh1216 2020-11-25T16:16:04Z Re: Convert if to set analysis? https://community.qlik.com/t5/QlikView/Convert-if-to-set-analysis/m-p/1249553#M871357 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you can use pick &amp; match for the same thing..</P><P></P><P>like this:&nbsp; pick(match(TOOL,'A','B','C'),'A1','B1','C1')</P></BODY></HTML> Tue, 15 Nov 2016 06:55:28 GMT https://community.qlik.com/t5/QlikView/Convert-if-to-set-analysis/m-p/1249553#M871357 sushil353 2016-11-15T06:55:28Z Re: Convert if to set analysis? https://community.qlik.com/t5/QlikView/Convert-if-to-set-analysis/m-p/1249554#M871358 <HTML><HEAD></HEAD><BODY><P>Set expressions are filters, not branching constructs. Nested IF() or Pick() are adequate solutions for this type of operation.</P></BODY></HTML> Tue, 15 Nov 2016 06:58:44 GMT https://community.qlik.com/t5/QlikView/Convert-if-to-set-analysis/m-p/1249554#M871358 jonathandienst 2016-11-15T06:58:44Z Re: Convert if to set analysis? https://community.qlik.com/t5/QlikView/Convert-if-to-set-analysis/m-p/1249555#M871359 <HTML><HEAD></HEAD><BODY><P>Hi Gireesh</P><P>Set Analysis can be used only in the Aggr function .</P><P></P><P>my suggestion use pick Function&nbsp; as follows.</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=pick(match(TOOL,'A','B','C'),'A1','B1','C1')</SPAN></P></BODY></HTML> Tue, 15 Nov 2016 07:00:53 GMT https://community.qlik.com/t5/QlikView/Convert-if-to-set-analysis/m-p/1249555#M871359 Anonymous 2016-11-15T07:00:53Z Re: Convert if to set analysis? https://community.qlik.com/t5/QlikView/Convert-if-to-set-analysis/m-p/1249556#M871360 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Tue, 15 Nov 2016 07:20:47 GMT https://community.qlik.com/t5/QlikView/Convert-if-to-set-analysis/m-p/1249556#M871360 gireesh1216 2016-11-15T07:20:47Z Re: Convert if to set analysis? https://community.qlik.com/t5/QlikView/Convert-if-to-set-analysis/m-p/1249557#M871361 <HTML><HEAD></HEAD><BODY><P>Thanks for all</P></BODY></HTML> Tue, 15 Nov 2016 07:21:30 GMT https://community.qlik.com/t5/QlikView/Convert-if-to-set-analysis/m-p/1249557#M871361 gireesh1216 2016-11-15T07:21:30Z