Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

senthilkumar_c1
New Contributor

Ignore selection in Set Analysis

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))

1 Solution

Accepted Solutions
MVP
MVP

Re: Ignore selection in Set Analysis

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))


Set Analysis in the Aggr function

2 Replies
MVP
MVP

Re: Ignore selection in Set Analysis

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))


Set Analysis in the Aggr function

senthilkumar_c1
New Contributor

Re: Ignore selection in Set Analysis

Hi Stefan,

Its working . Thanks for your immediate response .

Community Browser