Evaluate Multiple set analysis expression in one equation

Fri, 18 Jan 2013 17:28:43 GMT

Perhaps I am just missing the syntax or my (Join together) expression is wrong. I would like to take first and second and join them together into one expression. Is this the correct way to do this because it does not appear to be working? How do you join both of these together? Probably simplier than I am thinking...

//First
sum({$<SaleRepCustom_ID = {2} >} JonesHouse50_Sales) 
//Second
sum({$<YearFiscal={$(=max(year(YearFiscal))-1)}>} JonesHouse50_Sales) 
//Join together
sum({$<YearFiscal={$(=max(year(YearFiscal))-1)}>} {$<SaleRepCustom_ID = {2} >} JonesHouse50_Sales)

Thanks for any assitance.

Re: Evaluate Multiple set analysis expression in one equation

Fri, 18 Jan 2013 17:40:30 GMT

Jake,

Assuming your individual expressions are working fine, this should give you the result:

=sum({$<SaleRepCustom_ID = {2},YearFiscal={$(=max(year(YearFiscal))-1)}>} JonesHouse50_Sales)

Conditions in set analysis can be seperated by a comma (as above).

Hope that helps,

Regards,

-Khaled.

topic Re: Evaluate Multiple set analysis expression in one equation in QlikView

Evaluate Multiple set analysis expression in one equation

Re: Evaluate Multiple set analysis expression in one equation