Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

Data Format Issue

Hi All,

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.

Regards,

Sarif

9 Replies
oknotsen
Master III
Master III

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.

May you live in interesting times!
undergrinder
Specialist II
Specialist II

Hi Mohammad,

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.

G.

mhmmd_srf
Creator II
Creator II
Author

Hi Undergrinder,

It is a calculated field in dashboard level. Like (x+y+z)/3. Can we make this string after calculation?

Regards,

Sarif

Not applicable

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.

Regards,

Michael

undergrinder
Specialist II
Specialist II

Yes, but i think it would be difficult.

Try michaelkingeic‌ suggestion, i think the #.# format code do the trick.

G.

mhmmd_srf
Creator II
Creator II
Author

Hi King,

I applied your solution. However still having same issue. Do we need to set any other data format along with above solution.

Regards,

Sarif

oknotsen
Master III
Master III

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 .

May you live in interesting times!
Not applicable

Do you have a sample file?

mhmmd_srf
Creator II
Creator II
Author

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?