Solved: explination? - Qlik Community

Report Inappropriate Content · ‎2014-09-24

='Sales : ' & Num(Sum(Sales), '#,##0')

jyothish8807 · ‎2014-09-24

Hi Manoj,

='Sales : ' & Num(Sum(Sales), '#,##0')

Sales with in ' ' will come as a text in out put

Num function will make sure the sum(sales) will in '#,##0' format. eg. 2,330

Regards

KC

Best Regards,
KC

View solution in original post

senpradip007 · ‎2014-09-24

What is your actual requirement?

Do you need this:

Text (Sales : ) + Sum(sales) in format '#,##0'

PrashantSangle · ‎2014-09-24

Hi,

Is this same question mention in this thread

expression how it works?

Num() is formated your output of Sum(Sales) in Integer format

and Sales is text appended using & special character.

& work as concat two fields.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

jyothish8807 · ‎2014-09-24

Hi Manoj,

='Sales : ' & Num(Sum(Sales), '#,##0')

Sales with in ' ' will come as a text in out put

Num function will make sure the sum(sales) will in '#,##0' format. eg. 2,330

Regards

KC

Best Regards,
KC

explination?

Related Topics