topic Re: If then in a select...help in QlikView

If then in a select...help

ecabanas — Fri, 02 Nov 2012 15:05:00 GMT

Hi, I'm loading these data and I want to check if the fiel SALESSTATUS is "" the wrtite "1" else leave as it is...

I load the table as you can see, but I don't knot how to do these if then condition...thank's everyone!!

Eduard

SALESLINE:

Load UPPER(ITEMID)AS ITEMID,SALESSTATUS,SALESID,QTYORDERED,INVENTTRANSID,CUSTACCOUNT,EVE_AMOUNTMSTEXCLTAX, year(CREATEDDATETIME)AS ANO, Month(CREATEDDATETIME)AS Mes;

SQL SELECT SALESID,ITEMID,SALESSTATUS,QTYORDERED,INVENTTRANSID,CUSTACCOUNT,CREATEDDATETIME,EVE_AMOUNTMSTEXCLTAX

from DynamicsAx.dbo.SALESLINE;

Concatenate (SALESLINE)

LOAD UPPER(ITEMID) AS ITEMID,SALESID,COSTAMOUNTPOSTED,year(INVOICEDATE)AS ANO, Month(INVOICEDATE)AS Mes;

SQL SELECT ITEMID,SALESID,COSTAMOUNTPOSTED,INVOICEDATE

FROM DynamicsAx.dbo.EVE_CUSTINVOICETRANS;

Re: If then in a select...help

MayilVahanan — Fri, 02 Nov 2012 15:21:37 GMT

Try like this

Load *, if(Len(trim(SALESSTATUS)) = 0 or IsNull(SALESSTATUS),1,SALESSTATUS) as SALESSTATUS from tablename;

Re: If then in a select...help

ecabanas — Fri, 02 Nov 2012 15:41:11 GMT

hi all!!! this does not work.....grrrrrrrr I'm very tired and I want to solve the problem!!!

Re: If then in a select...help

MayilVahanan — Fri, 02 Nov 2012 16:12:21 GMT

Len(trim(salesstatus)) = 0 , not solve ?

can you post a sample file?