CHANGE FORMATT PATTERN

[fdelacal]

I need to change FORMATT PATTERN i want to introduce my variable.

My variabble for example will be vMoney and the value is #.##0,00 €;-#.##0,00 € or #.##0,00 $;-#.##0,00 $ or...........

depend my selection, automactly change that value.

Thanks in advance

[Anonymous]

check attached..

hope that helps..

[fdelacal]

I DO THAT, NO PROBLEM FOR THAT I ATACH A IMAGE TO SEE WHAT I AM TRAING TO DO.Ç

[rwunderlich]

You can't use a variable in the Format Pattern dialog box. Sorry.

-Rob

[Anonymous]

As Rob said, you cannot use a variable in the Format Pattern section.

Instead you can try something like below...

Money(<your expression>, '$(vMoney)')

in your expression itself use the format variable..

[fdelacal]

i am traing to change FORMATT PATTERN because if i change that when i export to excel it recognize like a numer,

if i put that Money(<your expression>, '$(vMoney)') or num(<my expression>, '$(vMoney)') when i export to excel it is to excel like a text(not a numer) and i can´t do opertations in excel like sum for example.

see this case. http://community.qlik.com/message/267508#267508

[Anonymous]

have updated that discussion with the QVW.. please check..