topic dimension if skript in QlikView https://community.qlik.com/t5/QlikView/dimension-if-skript/m-p/131579#M19788 <HTML><HEAD></HEAD><BODY><P>Hi</P><P><SPAN class="short_text" lang="en">How should this be written?<BR /></SPAN><SPAN class="trans-verified-button goog-toolbar-button"><SPAN class="jfk-button-img"></SPAN></SPAN><BR />//dimension</P><P>if third mark is 1 is '1' and if third mark is 5 is '2'</P></BODY></HTML> Wed, 29 Aug 2018 08:15:43 GMT kkarlste 2018-08-29T08:15:43Z dimension if skript https://community.qlik.com/t5/QlikView/dimension-if-skript/m-p/131579#M19788 <HTML><HEAD></HEAD><BODY><P>Hi</P><P><SPAN class="short_text" lang="en">How should this be written?<BR /></SPAN><SPAN class="trans-verified-button goog-toolbar-button"><SPAN class="jfk-button-img"></SPAN></SPAN><BR />//dimension</P><P>if third mark is 1 is '1' and if third mark is 5 is '2'</P></BODY></HTML> Wed, 29 Aug 2018 08:15:43 GMT https://community.qlik.com/t5/QlikView/dimension-if-skript/m-p/131579#M19788 kkarlste 2018-08-29T08:15:43Z Re: dimension if skript https://community.qlik.com/t5/QlikView/dimension-if-skript/m-p/131580#M19789 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Try to use below expression</P><P></P><P><STRONG>pick ( match( [</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>third mark],1,5),'1','2')</STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Regards,</STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Prashant</STRONG></SPAN></P></BODY></HTML> Wed, 29 Aug 2018 09:14:18 GMT https://community.qlik.com/t5/QlikView/dimension-if-skript/m-p/131580#M19789 prashantsanchet 2018-08-29T09:14:18Z