NUM() functionality

[suhasarchak]

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

[CELAMBARASAN]

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

[SunilChauhan]

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

[dharmarasu]

hi,

use floor(sum(amount,0.1))

this will return like 12.27 -> 12.2

198.45->198.4

Hope this helps.

Dharma

[suhasarchak]

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

[suhasarchak]

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

[dharmarasu]

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