topic Re: How to use Format command in QlikView

How to use Format command

Thu, 18 Oct 2012 11:46:43 GMT

Hello All.

This issue is disturbing me.

I wld lik to format an amount in a text object

I use this expressions : = Money(Only(TOT_AMOUNT),'XAF #,##0.00;XAF #,##0.00)'). It works well. XAF is a currency.

But to globalize that expression, all my currecies are loaded in the field CCY, and i can get it by the following expression : = Only(CCY).

When i use this expression : = Money(Only(TOT_AMOUNT),'Only(CCY) #,##0.00;Only(CCY) #,##0.00)'). I have the screenshot below which is not correct display:

May be there is a strategy to map that Only(CCY) to have the correct display.

Please your help on that

Regards

Re: How to use Format command

Thu, 18 Oct 2012 11:50:53 GMT

Hi,

using text object, you can display any one currency, when you sum all the amounts having different currencies, which currency you want to display ?

Regards

Re: How to use Format command

Thu, 18 Oct 2012 11:57:57 GMT

Hai

You didn't get me.

the expression =Only(CCY) can give more than 5 currencies (XAF,XOF,USD,EUR,JPY,...).

I would like that when the user select one of those currency, the value change automatically.

Thanks in adavnce for your help

Re: How to use Format command

Thu, 18 Oct 2012 12:07:53 GMT

declare a variable vCCY=getfieldselections(CCY) & use it in place of only(CCY) in ur expression.

Hope it helps

Regards

Re: How to use Format command

Thu, 18 Oct 2012 12:16:23 GMT

Dear qlik_techie.

Let see the result below

I think it's because that expression is used in a string.

How may i match an expression in a string by taking only the return value?

That is the question.

Thank in advance for your help

Re: How to use Format command

Thu, 18 Oct 2012 12:26:27 GMT

hai qlik_techie

Nothing special without $ , see the screenshot

I think it's because that expression is used in a string.

How may i match an expression in a string by taking only the return value?

That is the question.

Standing by for your help

Re: How to use Format command

MayilVahanan — Thu, 18 Oct 2012 12:53:39 GMT

Please check the attached file..

Hope it helps

Re: How to use Format command

Thu, 18 Oct 2012 12:56:24 GMT

Hi Mayil,

Please i'm unable to open the file bcoz i'm using Qlikview Personal Edition.

If there is an expression, please paste it here. I 'll test it

Regards

Re: How to use Format command

MayilVahanan — Thu, 18 Oct 2012 13:02:53 GMT

Try like this

Money(Sum(Amount),vCurr&'$#,#00'))

where vCurr = GetFieldSelections(CurrencyField)

Hope it helps

Re: How to use Format command

Thu, 18 Oct 2012 13:15:21 GMT

Hi all.

I think the key was to know that "&" is the character used to concatenate the fields.

I use this expression

= Money(Only(TOT_AMOUNT), Only(CCY)&' #,##0.00;(' & Only(CCY) &' #,##0.00)')

I thank all the team for your help.