Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Error in if statement in load command

Hi

I am getting at if statement in below code:

SalesTable:
Load , sum() as Revenue, if(=12,sum(),0) as Freight
Resident Operations
Group by
;
Join(SalesTable)
Load [SO] as
, sum([Sales]) as SalesValue
Resident Sales
Group by [SO];

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

Can someone suggest how to write if statement?

1 Solution

Accepted Solutions
Sokkorn
Honored Contributor

Error in if statement in load command

Hi,

Let try this

Load

    ,

    sum() as Revenue,

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

Resident Operations

Group by ;

Regards,

Sokkorn

2 Replies
Sokkorn
Honored Contributor

Error in if statement in load command

Hi,

Let try this

Load

    ,

    sum() as Revenue,

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

Resident Operations

Group by ;

Regards,

Sokkorn

Not applicable

Error in if statement in load command

Thanks. Works

Community Browser