topic Re: Significant 3 digits in QlikView

Significant 3 digits

Tue, 29 Jul 2014 09:02:00 GMT

Hi ,

I have a field containing values like

1.1

1.2

12.90

1..2.3.00

545.6

From this I need to filte rout only

1.1

1.2

Kindly help

Thanks!

Re: Significant 3 digits

MK_QSL — Tue, 29 Jul 2014 09:05:10 GMT

Load

NUM(SubField(Replace(Number,'..','.'),'.',1)&'.'&SubField(Replace(Number,'..','.'),'.',2),'#,##0.00') as Number Inline

[

Number

1.1

1.2

12.90

1..2.3.00

545.6

];

If you want single digit after decimal point, use '#,##0.0' instead of '#,##0.00'

Re: Significant 3 digits

tobias_klett — Tue, 29 Jul 2014 09:14:39 GMT

Hi,
It would be best to check the "." and be sure there is a number in Front and end and there are three digits. Therefore you could only take the values you need into the field:

if(mid(fieldXY,2,1)='.' and isnum(left(fieldXY,1)) and isnum(right(fieldXY,1)) and len(fieldXY)=3, fieldXY as filteredXY,

or filter the whole table:
where mid(fieldXY,2,1)='.' and isnum(left(fieldXY,1)) and isnum(right(fieldXY,1)) and len(fieldXY)=3;