topic Re: Using Dual Function with Class in QlikView https://community.qlik.com/t5/QlikView/Using-Dual-Function-with-Class/m-p/1399589#M804461 <HTML><HEAD></HEAD><BODY><P>Thank you Anil</P></BODY></HTML> Thu, 16 Nov 2017 07:42:07 GMT Anonymous 2017-11-16T07:42:07Z Using Dual Function with Class https://community.qlik.com/t5/QlikView/Using-Dual-Function-with-Class/m-p/1399587#M804459 <HTML><HEAD></HEAD><BODY><P>I have the following calculated dimension class script:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0433ff;">Left</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0433ff;">Class</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #941100;">Amount</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">, 10), </SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0433ff;">FindOneOf</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0433ff;">Class</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #941100;">Amount</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">, 10), ' ',1))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&amp; ' - ' &amp;</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0433ff;">Num</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0433ff;">Mid</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0433ff;">Class</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #941100;">Amount</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">,10), </SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0433ff;">FindOneOf</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0433ff;">Class</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #941100;">Amount</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">, 10), ' ',4)))-1)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">How do i incorporate the 'Dual Function' in the above script for me to be able to sort the calculated dimension as a value?</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Regards.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Chris<BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Using-Dual-Function-with-Class/m-p/1399587#M804459 Anonymous 2020-11-25T16:16:04Z Re: Using Dual Function with Class https://community.qlik.com/t5/QlikView/Using-Dual-Function-with-Class/m-p/1399588#M804460 <HTML><HEAD></HEAD><BODY><P>Perhaps this?</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #000000; font-style: inherit; font-weight: inherit;"><STRONG>=Dual(</STRONG></SPAN><STRONG style="color: #000000;"><SPAN style="font-style: inherit;">Left</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Class</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Amount</SPAN><SPAN style="font-style: inherit;">, 10), </SPAN><SPAN style="font-style: inherit;">FindOneOf</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Class</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Amount</SPAN><SPAN style="font-style: inherit;">, 10), ' ',1)) </SPAN></STRONG><STRONG style="color: #000000; font-style: inherit;">&amp; ' - ' &amp; </STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="color: #000000;"><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Num</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Mid</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Class</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Amount</SPAN><SPAN style="font-style: inherit;">,10), </SPAN><SPAN style="font-style: inherit;">FindOneOf</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Class</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Amount</SPAN></STRONG><SPAN style="color: #000000; font-style: inherit; font-weight: inherit;"><STRONG>, 10), ' ',4)))-1), </STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="color: #000000;"><SPAN style="font-style: inherit;">Left</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Class</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Amount</SPAN><SPAN style="font-style: inherit;">, 10), </SPAN><SPAN style="font-style: inherit;">FindOneOf</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Class</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Amount</SPAN><SPAN style="font-style: inherit;">, 10), ' ',1)) &amp;</SPAN></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="color: #000000;"><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Num</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Mid</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Class</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Amount</SPAN><SPAN style="font-style: inherit;">,10), </SPAN><SPAN style="font-style: inherit;">FindOneOf</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Class</SPAN><SPAN style="font-style: inherit;">(</SPAN><SPAN style="font-style: inherit;">Amount</SPAN></STRONG><SPAN style="color: #000000; font-style: inherit; font-weight: inherit;"><STRONG>, 10), ' ',4)))-1)</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #000000; font-style: inherit; font-weight: inherit;"><STRONG>)<BR /></STRONG></SPAN></P></BODY></HTML> Thu, 16 Nov 2017 02:37:56 GMT https://community.qlik.com/t5/QlikView/Using-Dual-Function-with-Class/m-p/1399588#M804460 Anil_Babu_Samineni 2017-11-16T02:37:56Z Re: Using Dual Function with Class https://community.qlik.com/t5/QlikView/Using-Dual-Function-with-Class/m-p/1399589#M804461 <HTML><HEAD></HEAD><BODY><P>Thank you Anil</P></BODY></HTML> Thu, 16 Nov 2017 07:42:07 GMT https://community.qlik.com/t5/QlikView/Using-Dual-Function-with-Class/m-p/1399589#M804461 Anonymous 2017-11-16T07:42:07Z