topic Re: how to concat expression and string in QlikView https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126819#M909717 <HTML><HEAD></HEAD><BODY><P>am changed in number tab ,number format like ###########,### sqft</P><P>its working </P><P>thank&nbsp; a lot</P></BODY></HTML> Thu, 16 Jun 2016 11:22:30 GMT 2016-06-16T11:22:30Z how to concat expression and string https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126812#M909710 <HTML><HEAD></HEAD><BODY><P>hi , am new to qlick view .</P><P>and i have one expression</P><P>=num(sum(DISTINCT RNUNTS_SQFT_AREA)/Area_Divide,'#.###')</P><P>and i want to add string 'sqft' at chart<IMG alt="chart.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/128070_chart.PNG" style="height: auto;" /></P><P>i want to display like 0.02 sqft,0.35 sqft,0.71sqft .</P><P>thank in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126812#M909710 2020-11-25T16:16:04Z Re: how to concat expression and string https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126813#M909711 <HTML><HEAD></HEAD><BODY><P>Try: =num(sum(DISTINCT RNUNTS_SQFT_AREA)/Area_Divide,'#.### <STRONG>sqft</STRONG>')</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 16 Jun 2016 07:07:53 GMT https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126813#M909711 marcus_sommer 2016-06-16T07:07:53Z Re: how to concat expression and string https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126814#M909712 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=num(sum(DISTINCT RNUNTS_SQFT_AREA)/Area_Divide,'#.### sqft')</SPAN></P></BODY></HTML> Thu, 16 Jun 2016 07:13:21 GMT https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126814#M909712 santhoo_san 2016-06-16T07:13:21Z Re: how to concat expression and string https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126815#M909713 <HTML><HEAD></HEAD><BODY><P>AM tried&nbsp; that one already but not showing that particular&nbsp; formate</P></BODY></HTML> Thu, 16 Jun 2016 11:07:22 GMT https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126815#M909713 2016-06-16T11:07:22Z Re: how to concat expression and string https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126816#M909714 <HTML><HEAD></HEAD><BODY><P>You might need to change the number format to Default Expression on the Number tab of the chart properties. Have you done that already?</P></BODY></HTML> Thu, 16 Jun 2016 11:11:15 GMT https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126816#M909714 sunny_talwar 2016-06-16T11:11:15Z Re: how to concat expression and string https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126817#M909715 <HTML><HEAD></HEAD><BODY><P>Have you enabled within the tab numbers the number-format: expression?</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 16 Jun 2016 11:11:45 GMT https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126817#M909715 marcus_sommer 2016-06-16T11:11:45Z Re: how to concat expression and string https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126818#M909716 <HTML><HEAD></HEAD><BODY><P>i done already</P></BODY></HTML> Thu, 16 Jun 2016 11:17:44 GMT https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126818#M909716 2016-06-16T11:17:44Z Re: how to concat expression and string https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126819#M909717 <HTML><HEAD></HEAD><BODY><P>am changed in number tab ,number format like ###########,### sqft</P><P>its working </P><P>thank&nbsp; a lot</P></BODY></HTML> Thu, 16 Jun 2016 11:22:30 GMT https://community.qlik.com/t5/QlikView/how-to-concat-expression-and-string/m-p/1126819#M909717 2016-06-16T11:22:30Z