topic dual function in QlikView https://community.qlik.com/t5/QlikView/dual-function/m-p/1142823#M374206 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm using a dual function to create a dimension.</P><P></P><P>There's an issue which I cannot solve. Could you please have a look in the file attached?</P><P></P><P>Thank you in advance,</P><P></P><P>Larisa</P></BODY></HTML> Sun, 07 Aug 2016 14:27:59 GMT Anonymous 2016-08-07T14:27:59Z dual function https://community.qlik.com/t5/QlikView/dual-function/m-p/1142823#M374206 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm using a dual function to create a dimension.</P><P></P><P>There's an issue which I cannot solve. Could you please have a look in the file attached?</P><P></P><P>Thank you in advance,</P><P></P><P>Larisa</P></BODY></HTML> Sun, 07 Aug 2016 14:27:59 GMT https://community.qlik.com/t5/QlikView/dual-function/m-p/1142823#M374206 Anonymous 2016-08-07T14:27:59Z Re: dual function https://community.qlik.com/t5/QlikView/dual-function/m-p/1142824#M374207 <HTML><HEAD></HEAD><BODY><P>From the Ref Guide: Dual function.</P><P>"In QlikView, when several data items read into one field have different string representations but the same valid number representation, they will all share the first string representation encountered."</P><P></P><P>so in your case it is picking the first string as Object5 as the first string representation.</P><P></P><P>I am not sure how your data is defined. </P></BODY></HTML> Sun, 07 Aug 2016 15:41:17 GMT https://community.qlik.com/t5/QlikView/dual-function/m-p/1142824#M374207 vishsaggi 2016-08-07T15:41:17Z