topic Re: Apply numeric formats in QlikView

Apply numeric formats

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I would like to know a fast way to apply numeric formats in QV. For example num(sum(sales, '###.###,##')...

For example, in Excel I can copy and paste a defined numeric format, but in QV do I have to go

expression by expression. Can I recommend a fast way to do it??

What does mean a 0 in the format pattern??

Thanks

Re: Apply numeric formats

Anonymous — Tue, 12 Apr 2016 10:03:48 GMT

Hi Juan,

You could create a variable, let say vNumFormat and assign your format to that variable. Then use it the num expression:

=num(Field, $(vNumFormat))

If you need to change your format, you won't need to change each expression, but instead just change the value in the variable and it will apply wherever its contained.

About the zero, I think it has to do with the total of decimal positions that you want.

Hope it helps.

--Karla

Re: Apply numeric formats

Kushal_Chawda — Tue, 12 Apr 2016 10:06:50 GMT

If you have the expression as Sum(Sales) in straight table then go to properties -> number tab-> here you can set the various format like money, number , timestamp , date etc for that expression

Re: Apply numeric formats

Anonymous — Tue, 12 Apr 2016 10:10:00 GMT

The zero in the format means that if that digit is zero, then the zero is displayed. The # means that is the digit if zero it is not displayed.

Re: Apply numeric formats

vikasmahajan — Tue, 12 Apr 2016 10:10:27 GMT

go to properties -> number tab-> here you can set the various format like money, number , timestamp , date etc for that expression

copy number format & paste with following formula

Num( sum(Sales) , ' Copy here number format')

Hope this is short way

vikas

Re: Apply numeric formats

amayuresh — Tue, 12 Apr 2016 10:20:37 GMT

Try this, Select multiple expression in Number Tab and apply same format for selected expression.

Re: Apply numeric formats

Anonymous — Tue, 12 Apr 2016 10:43:21 GMT

Ok, thanks, but then copy - paste of formats like Excel does not exists?

Re: Apply numeric formats

kkkumar82 — Tue, 12 Apr 2016 11:01:29 GMT

Yes, think in the way of Qlik , you can't mimic everything that you have in Excel here

Re: Apply numeric formats

engishfaque — Tue, 12 Apr 2016 11:05:44 GMT

Dear Juan,

Maintain your Number format sheet and load through loop in your App and apply whatever you want the format on your fields.

Go to Properties > Tab "Number" > Select your Expression/Field Name > Number Format Settings > Select your required Format > Copy Format Pattern > Apply > OK.

Now you can apply copied format pattern with Num function. Example: =Num(Sum(Sales), '#,##0.00')

Kind regards,

Ishfaque Ahmed

Re: Apply numeric formats

Anonymous — Tue, 12 Apr 2016 11:07:55 GMT

You can copy a whole expression including its format. Right click it on the expression on the Expressions tab of your source chart and copy it and then on your target chart Expressions tab go to the bottom of all your expressions, right click on the white space just below your expressions and paste it in.

Re: Apply numeric formats

Anonymous — Tue, 12 Apr 2016 11:11:33 GMT

Sorry, I don't undestand option 1

Re: Apply numeric formats

engishfaque — Tue, 12 Apr 2016 11:37:47 GMT

Dear Juan,

Kindly find attached App for Option 1.

Kind regards,

Ishfaque Ahmed