topic Re: Issue with num format in QlikView

Issue with num format

Wed, 25 Nov 2015 15:59:43 GMT

Hi,

Can someone please help me with the number format? I want to implement 3 significant figures in my dashboard.

Please find the sample dashboard and a screenshot explaining the requirement.

Thank you.

Regards,

Sachin

Re: Issue with num format

sunny_talwar — Wed, 25 Nov 2015 16:02:27 GMT

Bar for C need to have one decimal and other bars need to be integer? Is that your requirement?

Re: Issue with num format

Wed, 25 Nov 2015 16:05:13 GMT

Nope Sunny.

Every time the output should have 3 digits.

If it is 564.324, it should be displayed as 564.

If it is 0.212, it should be displayed as 0.21.

Re: Issue with num format

sunny_talwar — Wed, 25 Nov 2015 16:05:50 GMT

May be this as your expression:

If(Stock = 'C', Num(Sum(Price), '#,##0.0'), Num(Sum(Price), '#,##0'))

Re: Issue with num format

sunny_talwar — Wed, 25 Nov 2015 16:06:14 GMT

Oh okay, that makes sense

Re: Issue with num format

Wed, 25 Nov 2015 16:06:33 GMT

question

I can see how the first bar is rounded to 549 (from 548.806) but how come the last bar was still has a decimal?

Is bar C supposed to be formatted differently? what about bar b - in the example they have the same values but what about if they have decimals in them?

Re: Issue with num format

Wed, 25 Nov 2015 16:08:58 GMT

Hi Adam,

Every time the output should have 3 digits.

If it is 564.324, it should be displayed as 564.

If it is 0.212, it should be displayed as 0.21.

Re: Issue with num format

sunny_talwar — Wed, 25 Nov 2015 16:12:39 GMT

Try this expression:

=If(Len(SubField(Num(Sum(Price), '#,##0.0'), '.', 1)) >= 3, Num(Sum(Price), '#,##0'),

If(Len(SubField(Num(Sum(Price), '#,##0.0'), '.', 1)) = 2, Num(Sum(Price), '#,##0.0'), Num(Sum(Price), '#,##0.00')))

Re: Issue with num format

Wed, 25 Nov 2015 16:24:45 GMT

based on that explanation, it sounds like sunny's first suggestion would ensure that, regardgless of the stock, since it is looking at the length of the field for each stock, and not looking at the values differently

Re: Issue with num format

Wed, 25 Nov 2015 16:28:43 GMT

I updated the qvw to have stock d and are showing side by side how it looks unformatted and then applied sunny's first formatting - If I understand, this is what you are looking for