topic Re: Script Help in QlikView

Script Help

Mahamed_Qlik — Tue, 29 Dec 2015 09:23:32 GMT

Hi All,

I have one field in my database suppose name as quantity.

I need Quantity field as only positive values in it in back end script only like :

Kindly help.

Regards,

Mahamed

arulsettu — Tue, 29 Dec 2015 09:24:55 GMT

may be this

fabs(Quantity) as field

PrashantSangle — Tue, 29 Dec 2015 09:33:10 GMT

If you want to convert - ve value in +ve then use fabs()

if you want only +ve value then in where clause you can write

where Quantity>=0

Regards

avinashelite — Tue, 29 Dec 2015 09:40:03 GMT

if you need only +value s when you use the where condition in the script like

LOAD *

from

table

where Quantity>=0

raajaswin — Tue, 29 Dec 2015 09:49:05 GMT

Hi,

Also you can try purgechar(Fieldname,'-') or fabs() according to your format..