Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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