topic CHANGE FORMATT PATTERN in QlikView

CHANGE FORMATT PATTERN

fdelacal — Tue, 09 Oct 2012 15:22:29 GMT

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

Re: CHANGE FORMATT PATTERN

Anonymous — Tue, 09 Oct 2012 15:49:56 GMT

check attached..

hope that helps..

Re: CHANGE FORMATT PATTERN

fdelacal — Tue, 09 Oct 2012 16:18:36 GMT

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

Re: CHANGE FORMATT PATTERN

rwunderlich — Tue, 09 Oct 2012 16:36:20 GMT

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

-Rob

Re: CHANGE FORMATT PATTERN

Anonymous — Wed, 10 Oct 2012 05:48:54 GMT

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..

Re: CHANGE FORMATT PATTERN

fdelacal — Wed, 10 Oct 2012 07:15:54 GMT

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

Re: CHANGE FORMATT PATTERN

Anonymous — Wed, 10 Oct 2012 08:40:55 GMT

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