topic decimal value up to 2 in QlikView

decimal value up to 2

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

Hi every one , I have one field Pressure .How can i limit the values of these field up to 2 decimal .

I have values like 1485697456 in it.

Regards

Manu

Re: decimal value up to 2

its_anandrjs — Wed, 04 Oct 2017 15:59:25 GMT

What is expected output.

Re: decimal value up to 2

its_anandrjs — Wed, 04 Oct 2017 16:02:41 GMT

May be

=num( '1485697456','#,##0.00')/100

Re: decimal value up to 2

vishsaggi — Wed, 04 Oct 2017 16:04:33 GMT

May be using Num()function like

Num(YourNumberfield, '#,##0.00')

Re: decimal value up to 2

its_anandrjs — Wed, 04 Oct 2017 16:08:35 GMT

In load statement, you can try this

Load

Num( Fieldname,'#,##0.00') as NewName

From.....

Re: decimal value up to 2

sunny_talwar — Wed, 04 Oct 2017 16:26:33 GMT

Where is the decimal in this number?

1485697456

Re: decimal value up to 2

manu1512 — Thu, 05 Oct 2017 13:04:06 GMT

Hi Sunny,

The values are like 455,82261

Re: decimal value up to 2

manu1512 — Thu, 05 Oct 2017 13:04:54 GMT

Vishwarth the values are like 155,882261

Re: decimal value up to 2

sunny_talwar — Thu, 05 Oct 2017 13:09:27 GMT

Seems like your decimal separator is a comma, is that right? If that is true, can you check if you have this in your environmental variables

SET ThousandSep='.';

SET DecimalSep=',';

If you do, then this seems to work

=Num('455,82261', '#.##0,00')

Re: decimal value up to 2

Shubham_Deshmukh — Thu, 05 Oct 2017 13:12:06 GMT

If you want to restrict values after decimal points

eg. 455.XXXXXXXXXXXXXXXXXXX to 455.XX

Then there are 2ways,

1) Simply go to Properties->Number,enable fixed radio button there & gives your required range.

2)You can use function Round() eg. Round(condition/count, '#####.##')

Re: decimal value up to 2

manu1512 — Thu, 05 Oct 2017 13:14:09 GMT

Thanks sunny it is there ,Can you pls help me in getting used to syntax of tyd and qtd functions as i am finding difficulty in getting used to these long function

Re: decimal value up to 2

sunny_talwar — Thu, 05 Oct 2017 13:18:54 GMT

tyd and qtd? how is this linked to 2 decimals?

Re: decimal value up to 2

manu1512 — Thu, 05 Oct 2017 13:25:59 GMT

these are not linked to ytd qtd mtd i am just asking to you

Re: decimal value up to 2

sunny_talwar — Thu, 05 Oct 2017 13:30:32 GMT

In general, it is not a good idea to merge two different requirement in a single thread... 1) You don't get enought coverage 2) it gets confusing for future visitors..

I would suggest you to create a new thread for this new requirement and provide more details as to what you have and what you are looking to get.

As for this thread, if you got what you wanted, please close this thread by marking correct and helpful responses.

Best,

Sunny

Re: decimal value up to 2

manu1512 — Thu, 05 Oct 2017 13:56:38 GMT

Done

Re: decimal value up to 2

manu1512 — Thu, 05 Oct 2017 14:02:33 GMT

Thanks shubham

Re: decimal value up to 2

sunny_talwar — Thu, 05 Oct 2017 14:15:25 GMT

Thank you Manu!!! Now let us know when you create a new thread and I am more than happy to respond there

Re: decimal value up to 2

manu1512 — Thu, 05 Oct 2017 15:28:56 GMT

Sure Sunny

Re: decimal value up to 2

Shubham_Deshmukh — Fri, 06 Oct 2017 05:14:08 GMT

Welcome