topic Re: explination? in QlikView https://community.qlik.com/t5/QlikView/explination/m-p/679404#M1060404 <HTML><HEAD></HEAD><BODY><P>What is your actual requirement?</P><P></P><P>Do you need this:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Text (Sales : ) + Sum(sales) in format '#,##0'</SPAN></P></BODY></HTML> Wed, 24 Sep 2014 06:26:03 GMT senpradip007 2014-09-24T06:26:03Z explination? https://community.qlik.com/t5/QlikView/explination/m-p/679403#M1060403 <HTML><HEAD></HEAD><BODY><P></P><P>='Sales : ' &amp; Num(Sum(Sales), '#,##0') </P></BODY></HTML> Wed, 24 Sep 2014 06:21:45 GMT https://community.qlik.com/t5/QlikView/explination/m-p/679403#M1060403 2014-09-24T06:21:45Z Re: explination? https://community.qlik.com/t5/QlikView/explination/m-p/679404#M1060404 <HTML><HEAD></HEAD><BODY><P>What is your actual requirement?</P><P></P><P>Do you need this:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Text (Sales : ) + Sum(sales) in format '#,##0'</SPAN></P></BODY></HTML> Wed, 24 Sep 2014 06:26:03 GMT https://community.qlik.com/t5/QlikView/explination/m-p/679404#M1060404 senpradip007 2014-09-24T06:26:03Z Re: explination? https://community.qlik.com/t5/QlikView/explination/m-p/679405#M1060405 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is this same question mention in this thread</P><P></P><P><A href="https://community.qlik.com/thread/134688">expression how it works?</A></P><P></P><P></P><P>Num() is formated your output of Sum(Sales) in Integer format</P><P></P><P>and Sales is text appended using &amp; special character.</P><P></P><P>&amp; work as concat two fields.</P><P></P><P>Regards</P></BODY></HTML> Wed, 24 Sep 2014 06:33:01 GMT https://community.qlik.com/t5/QlikView/explination/m-p/679405#M1060405 PrashantSangle 2014-09-24T06:33:01Z Re: explination? https://community.qlik.com/t5/QlikView/explination/m-p/679406#M1060406 <HTML><HEAD></HEAD><BODY><P>Hi Manoj,</P><P></P><P>='Sales : ' &amp; Num(Sum(Sales), '#,##0') </P><P></P><P>Sales with in&nbsp; ' ' will come as a text in out put</P><P>Num function will make sure the sum(sales) will in '#,##0' format. eg. 2,330</P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Wed, 24 Sep 2014 06:35:49 GMT https://community.qlik.com/t5/QlikView/explination/m-p/679406#M1060406 jyothish8807 2014-09-24T06:35:49Z