topic Only() function Question in QlikView https://community.qlik.com/t5/QlikView/Only-function-Question/m-p/491440#M183646 <HTML><HEAD></HEAD><BODY><P>I'm having trouble with the return type of the Only() function. I have the expression:</P><P></P><P>if(Only(RawDescription) = Null(), 'Multiple', RawDescription)</P><P></P><P>The dimension I'm using a product code, so the data set from which Only() is choosing is significantly cut down relative to the entire data set. It seems pretty straight forward to me - if Only() finds multiple RawDescriptions for the same product code, it should return Null() (I think?). In that case - output the string 'Multiple'. Otherwise, simply output the sole RawDescription that it found.</P><P></P><P>When I apply this expression, the product codes with multiple descriptions still return '-'.</P><P></P><P>Any ideas?</P></BODY></HTML> Wed, 17 Jul 2013 15:25:40 GMT 2013-07-17T15:25:40Z Only() function Question https://community.qlik.com/t5/QlikView/Only-function-Question/m-p/491440#M183646 <HTML><HEAD></HEAD><BODY><P>I'm having trouble with the return type of the Only() function. I have the expression:</P><P></P><P>if(Only(RawDescription) = Null(), 'Multiple', RawDescription)</P><P></P><P>The dimension I'm using a product code, so the data set from which Only() is choosing is significantly cut down relative to the entire data set. It seems pretty straight forward to me - if Only() finds multiple RawDescriptions for the same product code, it should return Null() (I think?). In that case - output the string 'Multiple'. Otherwise, simply output the sole RawDescription that it found.</P><P></P><P>When I apply this expression, the product codes with multiple descriptions still return '-'.</P><P></P><P>Any ideas?</P></BODY></HTML> Wed, 17 Jul 2013 15:25:40 GMT https://community.qlik.com/t5/QlikView/Only-function-Question/m-p/491440#M183646 2013-07-17T15:25:40Z Re: Only() function Question https://community.qlik.com/t5/QlikView/Only-function-Question/m-p/491441#M183647 <HTML><HEAD></HEAD><BODY><P>Try if(isnull(only(RawDescription),'Multiple',RawDescription)</P></BODY></HTML> Wed, 17 Jul 2013 15:35:56 GMT https://community.qlik.com/t5/QlikView/Only-function-Question/m-p/491441#M183647 Gysbert_Wassenaar 2013-07-17T15:35:56Z Re: Only() function Question https://community.qlik.com/t5/QlikView/Only-function-Question/m-p/491442#M183648 <HTML><HEAD></HEAD><BODY><P>Perfect - thanks.</P><P></P><P>-Paul</P></BODY></HTML> Wed, 17 Jul 2013 15:58:00 GMT https://community.qlik.com/t5/QlikView/Only-function-Question/m-p/491442#M183648 2013-07-17T15:58:00Z