Baht (Thailand Currency) in Qlikview

[#1]

Hello Friends,

I have a requirement of displaying sales in Baht (฿) when exported in excel. Currently I format the measure by selecting 'money' and using the symbol (฿#,##0.00;-฿#,##0.00). This creates a text column in excel instead of number.

Above trick satisfies one part of requirement but the other is to do some calculation on the column like Commision*Sales. Since the column is text it will not work.

Thanks and Regards,

Umesh

[#2 · Accepted solution]

hi

try to set this global variable in script, then set baht like this

SET MoneyFormat='$#,##0.00;($#,##0.00)';

****************************************************

SET MoneyFormat='฿#,##0.00;(฿#,##0.00)';

[ashwanin]

You can do it in two ways. Either change the currency format in the properties of chart or set the currency format to THB in the script of your qvw. for more see the attached pic of both.

[Sokkorn]

Hi Umesh,

In script editor change some setting like this

SET MoneyFormat='฿#,##0.00;(฿#,##0.00)';

Then in expression, we can use =Money(Sum(Sale)) OR Sum(Sale) -> Go to number tab -> Choose Money

Regards,

Sokkorn

[#5]

Thanks All,

I tired SET MoneyFormat='฿#,##0.00;(฿#,##0.00)'; and it works