topic Re: Re: decimal values in QlikView

decimal values

Fri, 16 May 2014 12:48:27 GMT

Im new to qlikview.

i want to value in the chart like

22 = 22

and

22.22634547 = 22.23

but qlikview always show the value in the format

22 = 22.00

22.22634547 = 22.23

Re: decimal values

Fri, 16 May 2014 12:56:02 GMT

Hi,

In the properties of your object (right click on the object -> properties) you have a "Number" window, in this window, you can specify how many decimals you want.

Re: decimal values

Fri, 16 May 2014 13:00:07 GMT

Format as number with precision 2.

The format pattern should look like "#,###"

For the values

22.22634547

22.23

this should result in:

Re: decimal values

crusader_ — Fri, 16 May 2014 13:05:32 GMT

Hi Rabia,

You should check whether your number has fractional part:

if(frac(Number)=0, num(Number,'###'), num(Number,'###,##'))

Hope this helps.

Andrei

Re: decimal values

Fri, 16 May 2014 13:16:08 GMT

hi there;
thanks for reply but i need this to be done in my chart, i made a chart and its not showing values in two decimals, as in, if i select fixed to 2 decimal values it shows 22.00 rather than the actual point value it must show(22.45), i dunno how to solve that. do share if yu've ever came across this

Re: decimal values

Fri, 16 May 2014 13:32:43 GMT

Rabia,

it's the same setting: right click, choose properties, number. Make sure you select "Override document settings", choose type "Number" and 2 as precision. If needed you can override the default format pattern to "##,##"

I assume the value is used as an expression and not a dimension?

Re: decimal values

Mon, 19 May 2014 04:45:05 GMT

I tried the number format, its showing me 22.00. and yes value is used as an expression.

Re: decimal values

Mon, 19 May 2014 04:46:14 GMT

hi andrei

ive three expressions, so shall i paste this above code in all three of the expressions?

Re: decimal values

crusader_ — Mon, 19 May 2014 05:49:35 GMT

Hi Rabia,

You should paste this code in all expression which you want to be shown in such manner.

If there are 3 expressions - paste them instead "Number" in above code.

Hope this helps.

Andrei

Re: decimal values

Mon, 19 May 2014 06:03:13 GMT

What is the number format used in 'Number' tab??

Re: decimal values

crusader_ — Mon, 19 May 2014 06:42:57 GMT

Default because you define Number format in your expression.

PFA

Andrei !

Re: decimal values

Mon, 19 May 2014 06:45:55 GMT

With 'Expression default' it should give the right number format.

Re: decimal values

nizamsha — Mon, 19 May 2014 06:49:45 GMT

pls post ur sample app

Re: decimal values

Mon, 19 May 2014 06:52:39 GMT

guys its not giving me... its still same and for the expression part, ive already codes in them. can i add more expression in the already expressioned chart?

Re: decimal values

ashfaq_haseeb — Mon, 19 May 2014 07:01:52 GMT

Hi,

Can you post your sample app.

So that we can help you.

Regards

ASHFAQ

Re: decimal values

Mon, 19 May 2014 07:29:43 GMT

no im asking something else

Re: decimal values

Mon, 19 May 2014 07:30:00 GMT

okay lemme try this

Re: decimal values

Mon, 19 May 2014 07:30:13 GMT

no its not like that

Re: decimal values

Mon, 19 May 2014 07:30:42 GMT

##.##

Re: Re: decimal values

anbu1984 — Wed, 21 May 2014 05:56:44 GMT

Try this