Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Number formatting is not working fine

Hi All,

PFA.

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

Please suggest.

thanks

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

4 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
deepakqlikview_123
Specialist
Specialist
Author

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

sunny_talwar

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

deepakqlikview_123
Specialist
Specialist
Author

Thanks Sunny