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.