topic Change format in a text object in QlikView

Change format in a text object

Fri, 30 Apr 2010 17:01:31 GMT

Hello,

I am trying to change format to a number to display currency. The bloew formula is in the text tab of a tect object:

=money#(sum ( if (vButtonColour = 'Yesterday' AND FlagYesterday =1, csi_eur_handle)), '€#,##0')

The formula works for the sum but not for the money#. Can you please advice on how to do this?

Thanks

Matteo

Change format in a text object

Fri, 30 Apr 2010 19:16:37 GMT

I think you want money(), not money#(). According to the tool tip, money#() is for converting text to money, whereas money() converts a number to money.

You could also probably use num().

Change format in a text object

stephencredmond — Fri, 30 Apr 2010 19:18:16 GMT

Hi Matteo,

The format string in Money# function (as with Num# and Date#) defines the format of the incoming value - so if you were reading a text value that had a currency value in it the you use the Money#. What you need to use is the plain Money function. (In fact Num will work too).

Regards,

Stephen

Change format in a text object

Fri, 30 Apr 2010 20:50:36 GMT

Thanks for your reply.

I have tried with and without # for money() and num() but it does not work.

In the text tab I have 3 sums (as below)

Does that matter? It should not.

=money#(sum ( if (vButtonColour = 'Yesterday' AND FlagYesterday =1, csi_eur_handle)), '€#,##0') + money#(sum ( if (vButtonColour = 'Yesterday' AND FlagYesterday =1, csi_eur_handle)), '€#,##0') + money#(sum ( if (vButtonColour = 'Yesterday' AND FlagYesterday =1, csi_eur_handle)), '€#,##0')

Thanks again,

Matteo

Change format in a text object

stephencredmond — Sat, 01 May 2010 01:21:38 GMT

Hi,

I presume that sum ( if (vButtonColour = 'Yesterday' AND FlagYesterday =1, csi_eur_handle)) returns a numeric value? If so, you don't need to use Money#. Money# works on text values. Money works on numeric values. See my previous post.

I would change your expression to read:

=money(sum ( if (vButtonColour = 'Yesterday' AND FlagYesterday =1, csi_eur_handle))
+ sum ( if (vButtonColour = 'Yesterday' AND FlagYesterday =1, csi_eur_handle))
+ sum ( if (vButtonColour = 'Yesterday' AND FlagYesterday =1, csi_eur_handle)), '€#,##0')

However, all 3 sums appear to be the same - is that correct?

Regards,

Stephen

Change format in a text object

Sat, 01 May 2010 11:42:26 GMT

Thanks Stephen. It works now.

Just a single money() function before the whole expression. Thansk again.

Matteo

Re: Change format in a text object

Thu, 29 Jun 2017 14:34:40 GMT

Thank you! This is exactly what I need.