topic Re: NUM() functionality in QlikView

NUM() functionality

suhasarchak — Mon, 28 Jul 2014 06:38:58 GMT

Hi,

I am using the num() function in the expression to display a particular number format. But, the result is not as desired when the table/chart is exported to excel.

Fox Ex. the data as below:

Amount
12.235
100.2234
110.53243

Using Num(Amount,'#,##.0') I can limit the numbers to a single decimal as below:

Amount
12.2
100.2
110.5

But, the problem lies when I export this table to excel or use the output in some other table. The numbers not only get displayed to a single digit but also rounded to single digit. I do not want the number to be rounded but only limited to sigle digit for display purpose as I will be using these number for further calculation.

Can anybody help me to resolve this?

Thank you,

Suhas Archak

Re: NUM() functionality

CELAMBARASAN — Mon, 28 Jul 2014 06:51:56 GMT

Which version you are using? I'm using 11.2 SR6. It is working as expected.

Re: NUM() functionality

SunilChauhan — Mon, 28 Jul 2014 06:56:54 GMT

chart properties->number-> select number (1 in precisio)

Re: NUM() functionality

dharmarasu — Mon, 28 Jul 2014 07:01:03 GMT

hi,

use floor(sum(amount,0.1))

this will return like 12.27 -> 12.2

198.45->198.4

Hope this helps.

Dharma

Re: NUM() functionality

suhasarchak — Mon, 28 Jul 2014 07:01:08 GMT

Hi Celambarasan,

Thanks for your reply.

I am using 11.2 SR2, I am not sure if my problem is resolved in SR6

My issue was, for eg. 12.335 should only be displayed as 12.3 but for calculation qlikview should pick 12.335 as is. My limitation is that I have to use the NUM() function not number format from the Number tab from object properties.

If this issue is resolved by upgrading to SR6, I would.

Thanks,

Suhas Archak

Re: NUM() functionality

suhasarchak — Mon, 28 Jul 2014 07:10:41 GMT

Hi Dharma,

Thanks for your reply.

I do not want the number to be rounded, but formatted to display to a single digit. I think Floor() will round down the number.

Thank you,

Suhas Archak

Re: NUM() functionality

dharmarasu — Mon, 28 Jul 2014 07:12:56 GMT

no...it will not round the number..pls check it...