Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr in if statement within set analysis?

Hi,

i am new in qlikview, i have some question. in expression if i use this query:

=aggr(if(Month=Contract_Month and Year=Contract_Year,sum({<Scope={'Marketing'},MaterialTypeSales={'CPO'},DataVersion={'1'}>}Qty)),Month,Year,Contract_Month,Contract_Year)

it's showing the Sum(Qty).

but if i remove the aggregation, why the calculation is false / not showing?

Thanks.

0 Replies