Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr Expression Problem

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.

3 Replies
Sokkorn
Master
Master

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

Not applicable
Author

Hi Sokkorn,

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

Rgds,

Gauraw

Sokkorn
Master
Master

Hi Gauraw,

Can you attached your app here?

Regards,

Sokkorn