Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum() with several parameters from different sources

Hi guys,

can you tell me: is it possible to sum(amount) with several parameters, with are from different sources?

like this:

Sales:

Load EntryNo as Key1,

     DocNo,

     Date,

     Amount,

     GlobalDim1,

     GlobalDim2

SQL SELECT* FROM X;

SalesPerson:

Load EntryNo as Key1,

     DimCode,

     DimCodeValue as Salesperson

     WHERE MATCH(DimCode,'Salesperson')

SQL SELECT * FROM Y;

SUM1:

Load DocNo,

     '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 ?

thank you

1 Reply
sasiparupudi1
Master III
Master III

Try like this

Sales:

Load EntryNo as Key1,

     DocNo,

     Date,

     Amount,

     GlobalDim1,

     GlobalDim2;

SQL SELECT* FROM X;

left Join(Sales)

Load EntryNo as Key1,

     DimCode,

     DimCodeValue as Salesperson

     WHERE MATCH(DimCode,'Salesperson');

SQL SELECT * FROM Y;

NoConcatenate

SUM1:

Load DocNo,

     'DirectSales-AA' as SalesGroup,

     sum(Amount) as TotalAmount

     Resident Sales

     where (GlobalDim1<=500 AND GlobalDim1>=400) AND Match(Salesperson,'AA')

     group by DocNo,'DirectSales-AA';