Discussion Board for collaboration on QlikView Scripting.
can you tell me: is it possible to sum(amount) with several parameters, with are from different sources?
Load EntryNo as Key1,
SQL SELECT* FROM X;
DimCodeValue as Salesperson
SQL SELECT * FROM Y;
'DirectSales-AA' as SalesGroup,
sum(Amount) as SUMSUM Resident Sales (AND RESIDENT Sales ?) Where (GlobalDim1<=500 AND GlobalDim1>=400) AND Match(Salesperson,'AA')
How I formulate like in SUM1 ?
Try like this
sum(Amount) as TotalAmount
where (GlobalDim1<=500 AND GlobalDim1>=400) AND Match(Salesperson,'AA')
group by DocNo,'DirectSales-AA';