Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr in if statement within set analysis?


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?


0 Replies