Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm new in qlikview development and i want to use aggr function with set analysis. I have a problem when i use the following expression in my report because the "Month = " is ignore. Can i have more details about posibilities with aggr function and some advice in my scripting.
Avg(
aggr(
sum ( {<Month = >} indicator )
,Tech_Center,Region
)
)
Lionel T.
You may need to add the set expression also to the outer aggregation:
Avg({<Month = >}
aggr(
sum ( {<Month = >} indicator )
,Tech_Center,Region
)
)
Dear.... let us know your requirements or something about data and fields....
You may need to add the set expression also to the outer aggregation:
Avg({<Month = >}
aggr(
sum ( {<Month = >} indicator )
,Tech_Center,Region
)
)
Hello,
As you stated qlikview dont pay attention to the month selection... is not what you want? ´casue the expression is alright at best of my knowledge.
regards
Try with this
Avg({<Month = >}
aggr(
sum ( {<Month = >} indicator )
,Tech_Center,Region
)
)