topic Re: Loading IF statement in QlikView

Loading IF statement

Thu, 31 Mar 2016 03:57:38 GMT

Hi,

I am struggling with the loading script using IF below, appreciate anyone's help :

[TCODE]:
LOAD fileNumber

if(([trackCode]='BOOKED') AND [TransportMode]={'B','V'}) as TB
if(([trackCode]='BOOKCONF) AND [TransportMode]={'P','T'}) as TD
resident [Shipment];

The shipment already has trackCode and TransportMode fields, the problem is the syntax error.

Thank you.

Regards,

Re: Loading IF statement

swuehl — Thu, 31 Mar 2016 10:19:06 GMT

Your if() statements need at least a THEN branch, and check your string value matching, like

if(([trackCode]='BOOKED') AND Match([TransportMode],'B','V'), 'Yipiieh!' ) as TB

Re: Loading IF statement

sunny_talwar — Thu, 31 Mar 2016 10:20:00 GMT

May be try this:

[TCODE]:
LOAD fileNumber

If([trackCode]='BOOKED' and WildMatch([TransportMode], 'B','V'), 1, 0) as TB
If([trackCode]='BOOKCONF' and WildMatch([TransportMode], 'P','T'), 1, 0) as TD
Resident [Shipment];

Re: Loading IF statement

Chanty4u — Thu, 31 Mar 2016 10:28:26 GMT

ur missing single quote

[TCODE]:
LOAD fileNumber

if(([trackCode]='BOOKED') AND [TransportMode]={'B','V'}) as TB
if(([trackCode]='BOOKCONF') AND [TransportMode]={'P','T'}) as TD
resident [Shipment];

Re: Loading IF statement

saniyask — Thu, 31 Mar 2016 10:56:21 GMT

Hi,

Please try this..

Regards,

Saniya

Re: Loading IF statement

Chanty4u — Thu, 31 Mar 2016 11:21:00 GMT

Hi,

It means i think Missing the single Quote

The shipment already has trackCode and TransportMode fields, the problem is the syntax error.

Re: Loading IF statement

satishkurra — Fri, 01 Apr 2016 20:41:03 GMT

Extending to sunny syntax, we can use below in Red to give a meaningful name using Dual

[TCODE]:
LOAD fileNumber

If([trackCode]='BOOKED' and WildMatch([TransportMode], 'B','V'), Dual('TransportModeBV',1), Dual('TransportModeNOTBV',0)) as TB
Resident [Shipment];