topic Re: Restricting a load by a specific field result in QlikView

Restricting a load by a specific field result

Mon, 07 Apr 2014 12:09:09 GMT

I have created a If statement

If( Len(Trim([Mat. Doc._WABLNR.AFRU]))>0, '1', '0') as Null. I only want to load the 1's. I am trying to figure out if I can write a formula to only load the items with the 1 result but am not having great success.

Re: Restricting a load by a specific field result

alexandros17 — Mon, 07 Apr 2014 12:13:19 GMT

If you use that formula in the script you may write:

Load

...

Where Len(Trim([Mat. Doc._WABLNR.AFRU]))>0

otherwise if you use the formula as dimension

you may write:

If( Len(Trim([Mat. Doc._WABLNR.AFRU]))>0, '1', Null())

and check the box exclude null values

Re: Restricting a load by a specific field result

Mon, 07 Apr 2014 12:56:17 GMT

Not to sound dense but I am having a hard time figuring out where to insert the Where statement. I have the below but the Where statement is obviously not in the right place.

LOAD

AS DATE,

AS ObjectID,

Plant_WERKS.AFRU AS Plant,

Yield_GMNGA.AFRU AS QuantityLabored,

AS MaterialDoc,

Type.conf._MANUR.AFRU,

Order_AUFNR.AFRU AS ProductionOrder,

If( Len(Trim())>0, '1', '0') as Null

Where Len(Trim())>0

FROM

…..

Re: Restricting a load by a specific field result

alexandros17 — Mon, 07 Apr 2014 13:02:14 GMT

The syntax is:

LOAD

....

FROM

…..

WHERE Len(Trim([Mat. Doc._WABLNR.AFRU]))>0

I think that

LOAD

AS DATE,

leads you to an error, you need to specify a field that is renamed as DATE (something like Load myField as DATE)

Hope it helps