Discussion Board for collaboration on QlikView Scripting.
I am getting at if statement in below code:
SalesTable:Load , sum() as Revenue, if(=12,sum(),0) as FreightResident OperationsGroup by ;Join(SalesTable)Load [SO] as , sum([Sales]) as SalesValue Resident SalesGroup 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?
Go to Solution.
Let try this
sum() as Revenue,
sum(if(=12,,0)) as Freight
Group by ;