topic Error in if statement in load command in QlikView

Error in if statement in load command

Thu, 17 May 2012 08:29:48 GMT

I am getting at if statement in below code:

I have declared 2 tables: Operations and Sales and now joining these two table by field .

Can someone suggest how to write if statement?

Sokkorn — Thu, 17 May 2012 08:41:50 GMT

Hi,

Let try this

Load

sum() as Revenue,

sum(if(=12,,0)) as Freight

Resident Operations

Group by ;

Regards,

Sokkorn

Thu, 17 May 2012 08:53:19 GMT

Thanks. Works