topic Help with syntax in load statement in QlikView

Help with syntax in load statement

Tue, 22 Nov 2011 09:56:27 GMT

Hi Everyone,

I am new to this and first post so hello all

Please could someone help with the syntax for this script

Existing code:

LOAD

BWKEY & '_' & mid(MATNR, findoneof(MATNR, '123456789')) as [Product Plant ID] , // Modified in v1.2

LBKUM as [Stock Quantity],

VPRSV as [Price Control Indicator], //Add in v2.71

What I want to add but do not know best syntax:

VERPR as [Item Current MAP] where VPRSV = V

STPRS as [Item Current MAP] where VPRSV = S

please could someone help me with this?

thanks!

Tue, 22 Nov 2011 10:21:32 GMT

Simple if statement should do. See below-

LBKUM as [Stock Quantity],

VPRSV as [Price Control Indicator], //Add in v2.71

if(VPRSV='S','STPRS',if(VPRSV='V','VERPR')) as [Item Current MAP]

Cheers,

Shyam

Tue, 22 Nov 2011 11:27:04 GMT

Hi Shyam,

Thanks very much for your help!

Rob