topic Re: Aggr Expression Problem in QlikView

Aggr Expression Problem

Wed, 15 May 2013 08:32:33 GMT

Hi All,

I am using Aggr function to evaluate a expression.Kindly refer the below expn.

Aggr

(sum({<Product_Name=,Gem_Segment=,Decile_Group=,Adoption_Segment=,

Physician_Name=, Call_Timeframe=p(Timeframe), ,Call_Agg_Period_Descr=p(Agg_Period_Descr)

>}Actual_Calls),Gem_Segment)

I have filter for Gem_segment. I want that this filter do not apply for above calculation.

But when I am aggregating this expn by Gem_Segment , the Gem_Segment Filter applies and value changes.

Kindly help me to correct this Expression.

Re: Aggr Expression Problem

Sokkorn — Wed, 15 May 2013 08:44:51 GMT

Hi Kumar,

Did you try this yet:

Only({1}

Aggr

(sum({1<Product_Name=,Gem_Segment=,Decile_Group=,Adoption_Segment=,

Physician_Name=, Call_Timeframe=p(Timeframe), ,Call_Agg_Period_Descr=p(Agg_Period_Descr)

>}Actual_Calls),Gem_Segment)

)

Regards,

Sokkorn

Re: Aggr Expression Problem

Wed, 15 May 2013 09:28:21 GMT

Hi Sokkorn,

Thanx for the Response........ this soln is not working..... ........ some other way......

Rgds,

Gauraw

Re: Aggr Expression Problem

Sokkorn — Wed, 15 May 2013 09:31:13 GMT

Hi Gauraw,

Can you attached your app here?

Regards,

Sokkorn