Hope you are doing well.
I am facing one issue in Qlik Sense. Need your help on this.
I have one chart Average Order against Time. Time is 00.00 to 11:45, 15 mins interval. In default view Avg is showing as 1 decimal. However if we see data for few hours it changes to 2 decimal. Is it normal for Qlik Sense?
Then I changed the data formatting to Number and two decimal. Now it is showing 2.00, 3.25 ect. However our customer want absolute value should absolute and decimal value should be decimal. So it would be 2, 3.25 etc.
How to handle this situation. Could you please help me on this.
Thanks in advance.
Teach your customer the basics of math.
2 can be a value between 1.50000000000 and 2.49999999999999999
2.00 can be a value between 1.9950000000 and 2.00499999999999999
So effectively 2 can actually be more than 2.4.
I think the 2.00, 3.25 format is better soultion than 2, 3.25 etc...
If your customer want it so hard try recreate these values in string/text.
Begin your expression with num( then after your expression closing bracket, add ,'#.#')
num(sum([Sales]),'#.#') as an example.
Though I should point out that I agree with others who have said including the extended values is a better option for clarity.
That is because the #.## format will only show 2 if the actual number is indeed 2.000000000000.
If the number is 2.0000000000001, it will show 2.00.
So... Effectively it does what you are asking, just not what you are hoping / expecting.
I still think you should teach your customer basic math .
okk.. i will make a local copy.. and paste it here... however what about my first question?? is it normal for Qlik sense?
Initially it is showing one decimal but when I am drilling down into chart it is showing 2 decimal?? How it got changed by default?