Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mhmmd_srf
Contributor

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
Honored Contributor III

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.

May you live in interesting times!
undergrinder
Valued Contributor II

Re: Data Format Issue

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
Contributor

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

Not applicable

Re: Data Format Issue

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
Valued Contributor II

Re: Data Format Issue

Yes, but i think it would be difficult.

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

G.

mhmmd_srf
Contributor

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

oknotsen
Honored Contributor III

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 .

May you live in interesting times!
Not applicable

Re: Data Format Issue

Do you have a sample file?

mhmmd_srf
Contributor

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?