topic Re: Greater than or equal to in pick match in App Development https://community.qlik.com/t5/App-Development/Greater-than-or-equal-to-in-pick-match/m-p/1194408#M22502 <HTML><HEAD></HEAD><BODY><P>maybe</P><P></P><P>=pick(wildmatch(floor(fabs(duration)), 9,8,7,6,5,4,3,2,1,0, '*'), 9,8,7,6,5,4,3,2,1,0,10)</P></BODY></HTML> Thu, 29 Sep 2016 18:18:59 GMT maxgro 2016-09-29T18:18:59Z Greater than or equal to in pick match https://community.qlik.com/t5/App-Development/Greater-than-or-equal-to-in-pick-match/m-p/1194407#M22501 <HTML><HEAD></HEAD><BODY><P>I've got an if statement like this...</P><P></P><P>&nbsp; <SPAN style="font-size: 12pt; font-family: 'courier new', courier;">&nbsp; if(fabs(duration) &gt;= 10, 10,</SPAN></P><P><SPAN style="font-family: 'courier new', courier; font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(fabs(duration) &gt;= 9, 9,</SPAN></P><P><SPAN style="font-size: 12pt; font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(fabs(duration) &gt;= 8, 8,</SPAN></P><P><SPAN style="font-size: 12pt; font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...</SPAN></P><P><SPAN style="font-size: 12pt; font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )))</SPAN></P><P></P><P>Can I turn it into a `pick(match())` statement?&nbsp; How?</P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P></BODY></HTML> Thu, 29 Sep 2016 17:44:31 GMT https://community.qlik.com/t5/App-Development/Greater-than-or-equal-to-in-pick-match/m-p/1194407#M22501 Anonymous 2016-09-29T17:44:31Z Re: Greater than or equal to in pick match https://community.qlik.com/t5/App-Development/Greater-than-or-equal-to-in-pick-match/m-p/1194408#M22502 <HTML><HEAD></HEAD><BODY><P>maybe</P><P></P><P>=pick(wildmatch(floor(fabs(duration)), 9,8,7,6,5,4,3,2,1,0, '*'), 9,8,7,6,5,4,3,2,1,0,10)</P></BODY></HTML> Thu, 29 Sep 2016 18:18:59 GMT https://community.qlik.com/t5/App-Development/Greater-than-or-equal-to-in-pick-match/m-p/1194408#M22502 maxgro 2016-09-29T18:18:59Z