topic Re: Count the decimal precision in QlikView

Count the decimal precision

hkg_qlik — Thu, 07 Jan 2016 22:15:56 GMT

Hi everyone,

I would like to count the decimal precision for the following inline load :

Table A

1.22

2.666

24.3335

889.6

The decimal precision count should be as follows (output)

1.22 = 2

2.666 = 3

24.3335 = 4

889.6 = 1

99 = 0

Is this possible in qlikview ? The idea is to capture the highest precision possible in a given table.

Regards,

Anonymous — Thu, 07 Jan 2016 22:25:47 GMT

Use this in your script:

Len(Trim(SubField(FieldName, '.', 2))) as Precision

Anonymous — Thu, 07 Jan 2016 22:30:55 GMT

Like this ?

len ( right ( 24.3335 , ( index ( 24.3335 , '.' ) + 1 ) ) )

petter — Thu, 07 Jan 2016 22:39:05 GMT

Len(Subfield(N,'.',2))

Where N is the name of the field in question.