9 Replies Latest reply: Jun 27, 2016 4:01 AM by Mohammad Sarif

# 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.

Regards,

Sarif

• ###### Re: Data Format Issue

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.

• ###### Re: Data Format Issue

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.

• ###### Re: Data Format Issue

Hi Undergrinder,

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

Regards,

Sarif

• ###### Re: Data Format Issue

Yes, but i think it would be difficult.

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

G.

• ###### Re: Data Format Issue

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

• ###### Re: Data Format Issue

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

• ###### Re: Data Format Issue

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 .

• ###### Re: Data Format Issue

Do you have a sample file?

• ###### Re: Data Format Issue

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?