topic Help with Set Analysis in QlikView

Help with Set Analysis

Fri, 30 Mar 2012 15:51:21 GMT

Hi,


Please can someone help me with below expression. I would like to ignore selection of GR month in below set analysis expression.
I tried using -
 Avg ({<GRMonth=>} aggr( Only({$<[MM_Exclude_Flag]= {0} >} MM_Total_Time),Delivery_Key))
It is giving same results when used without {<GRMonth=>} before aggr function as below.
 Avg (aggr( Only({$<[MM_Exclude_Flag]= {0} >} MM_Total_Time),Delivery_Key))
Please let me know the correct syntax.
Thanks in advance!

Help with Set Analysis

swuehl — Fri, 30 Mar 2012 16:08:31 GMT

Try including your ignored field also into the inner set expresssion:

=Avg ({<GRMonth=>} aggr( Only({$<[MM_Exclude_Flag]= {0}, GRMonth= >} MM_Total_Time),Delivery_Key))

Help with Set Analysis

Fri, 30 Mar 2012 18:20:28 GMT

Thanks for your help! It worked.