topic Re: Ignore selection in Set Analysis in QlikView

Ignore selection in Set Analysis

senthilkumar_c1 — Sun, 26 Nov 2017 16:54:48 GMT

Hi Experts,

I Want to ignore the branch selection in the below expression

Max(Aggr(sum(DISTINCT Area_Defect),Currentweek))

I have tried with below expression but its not working , Can anybody please suggest a solution for this

Max(Aggr(sum({<Branch=>}DISTINCT Area_Defect),Currentweek))

swuehl — Sun, 26 Nov 2017 16:59:49 GMT

Most of the time, you need to use the set expression in both inner and outer aggregation functions:

Max({<Branch=>} Aggr(sum({<Branch=>} DISTINCT Area_Defect),Currentweek))

senthilkumar_c1 — Sun, 26 Nov 2017 17:09:36 GMT

Hi Stefan,

Its working . Thanks for your immediate response .