topic Re: Deleting decimals in QlikView

Deleting decimals

Tue, 27 Aug 2013 14:41:55 GMT

Hi,

I'm a novice and it's difficult to use Qlikview within trainee.

I want to remove figures after comma and choose how many i remove

It's my expression and how I could make to remove figures after comma?

=(365*24-SUM({$<AnnéeDateCréationOT = {"= $( =Only(Tempyearname))" }> } Interval([Date fin intervention]-[Date création DI],'h')))/Count(ID_OT)

ex : 2, 34456

ex : 2, 34

Thanks

Re: Deleting decimals

Anonymous — Tue, 27 Aug 2013 14:43:52 GMT

use subfiled function like

something like this

=subfiled(expression,',',1)

hope it helps

Raj

Re: Deleting decimals

jpapador — Tue, 27 Aug 2013 14:44:35 GMT

If you are doing this within a chart go to the number tab and choose the Fixed To option and choose 2 decimal places. If you are doing this else where you can wrap the expression in a num() function like so:

Num((365*24-SUM({$<AnnéeDateCréationOT = {"= $( =Only(Tempyearname))" }> } Interval([Date fin intervention]-[Date création DI],'h')))/Count(ID_OT), '#,##0.00')

Re: Deleting decimals

Tue, 27 Aug 2013 14:51:54 GMT

Hi,

You have to use :

=num(yourNumber Or Expression, '0,00' ) --> x,xx

=num(yourNumber Or Expression, '0,0000' ) --> x,xxxx

Regards

Re: Deleting decimals

Gysbert_Wassenaar — Tue, 27 Aug 2013 17:08:18 GMT

If you want to really remove the decimals you can use the floor function. For example to keep two decimals: floor( ...myexpressionhere... , 0.01)

If you want to keep the decimals, but only display with a number of decimals of your choice then you can use then num function.

The difference is that with num the fraction will still exist and used if the result of the expression is used in calculations (like sum). Floor will really cut off the fraction so it will not be used in further calculations.