topic Re: Number formatting is not working fine in QlikView

Number formatting is not working fine

deepakqlikview_123 — Sat, 09 Dec 2017 10:33:58 GMT

Hi All,

PFA.

Whenever I am applying number formatting my all results on a chart getting disappeared.

Please suggest.

thanks

Re: Number formatting is not working fine

Gysbert_Wassenaar — Sat, 09 Dec 2017 10:50:43 GMT

What do you mean with 'my all results on a chart getting disappeared'. As far as I can tell there are results and they're still shown. The values are just so small that if you display only a couple of digits you only see a lot of zeros.

Re: Number formatting is not working fine

deepakqlikview_123 — Sat, 09 Dec 2017 13:59:12 GMT

Hi Gysbert,

Thanks for the response.

Take an example of first part number 30001036.

Initially, it is showing 0.00(default view).

when I can select 30001036 then it shows 0,97.

It looks like weird.In default view also it should display 0.97.

Same applied to other part numbers as well.

In an attachment, I applied number formatting fixed to 2 digits.

when I can set the number formatting as expression default then it can show the large number.

As per my understaning, it should display the number up to 2 digits when I can apply the formatting.

Thanks

Re: Number formatting is not working fine

sunny_talwar — Sat, 09 Dec 2017 14:53:38 GMT

You need to remove the equal sign from the variable vBasePrice and also, use $(vBasePrice) instead of vBasePrice in your expression... Check the attached

Re: Number formatting is not working fine

deepakqlikview_123 — Sat, 09 Dec 2017 18:04:17 GMT

Thanks Sunny