topic Re: Urgent Help in QlikView

Urgent Help

Thu, 03 Jan 2013 09:17:27 GMT

Hello Friends,

As I have created a expressions that is working fine but I want to add a currency symbol at the end.

like 77 666 €.

This is my expression =if(Title='Works', Sum({$<Year={$(=max(Year)-1)}>} [Amount in Euro]),

I tried putting & '€' that is not working.

Regards

Ammu

Re: Urgent Help

sujeetsingh — Thu, 03 Jan 2013 09:21:16 GMT

just Write as {Expression} &'$'

try it

Re: Urgent Help

Thu, 03 Jan 2013 09:32:07 GMT

Hi,

Thanks for your reply

As in the below I tried, no result.

=if(Title='Works', Sum({$<Year={$(=max(Year)-1)}>} [Amount in Euro]) & '€',

Regards

Ammu

Re: Urgent Help

khadeer — Thu, 03 Jan 2013 09:38:11 GMT

Hi Ammu,

If u r using in chart go to number and select ur expression, in that number format settings, u have different options, go to money u can edit that by keeping required currency symbol.

if u r using in text box

=num("Ur expression",'$. #,##0.00;'

Hope it will works

Re: Urgent Help

Thu, 03 Jan 2013 09:44:48 GMT

Hello,

You will be more efficient with the set analysis :

num( Sum({$<Title={'Works'}, Year={$(=max(Year)-1)}>} [Amount in Euro]),'# ##0,00 €;-# #0,00 €')

Amand Dupretz

Re: Urgent Help

Thu, 03 Jan 2013 09:54:37 GMT

Hi,

Thanks for your reply,

I am trying this expression in pivot table, as you said I tried, still no results.

=if(Title='Works', Num(Sum({$<Year={$(=max(Year)-1)}>} [Amount in Euro]) ,'# ##0 €'),

Regards

Ammu

Re: Urgent Help

khadeer — Thu, 03 Jan 2013 11:14:32 GMT

If u r using in pivot table, go to number tab and left side check ur expression in right side u have number format settings, in that go to money, if there is $ u have to modify with required cureency. it definitely work .

Re: Urgent Help

Fri, 04 Jan 2013 05:45:36 GMT

Hello Amand Dupretz,

Thanks for your reply, still I am unable to put a currency symbol in the expression, what you adivised is still not working and I can not use the Number format if I use the expressions will have the € symbol but I need to have only in Title One and title four.

Please adivse

=(Title='One'=Num(Sum({$<Year={$(=max(Year)-1)}>} [Freight in Euro]),'###0 €' )),

if(Title='Tow,Count({$<Year={$(=max(Year)-1)}>} Sequence),

if(Title='Three',Sum({$<Year={$(=max(Year)-1)}>}[ Weight]),

if(Title='Four',Num(Sum({$<ShipmentYear={$(=max(ShipmentYear)-1)}>}[Freight in Euro]/([Weight]/1000),'###0 € ')))))

Re: Urgent Help

johngouws — Fri, 04 Jan 2013 06:05:03 GMT

Hello Amanda,

I am not entirely sure of the solution, but recall coming across something like this before.

I think the issue is that when you place the Euro symbol after the value, it becomes text. So you may need to display the answer as text and not a 'Num' as per your set analysis.

Hopefully this can be of some assistance.

John

Re: Urgent Help

khadeer — Fri, 04 Jan 2013 06:26:49 GMT

If it possible share ur QVW file with some sample data.