Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
aatish12345
Creator II
Creator II

Bypassing field is not working in nested aggr expression

Hi All,

I have an expression  in below format

if(aggr( max(
if(aggr( max(
if(aggr( max(date(ReleaseDate)), Region) = [ReleaseDate],

[MovieNumber])), Region) = [MovieNumber],

date(BreakEvenDate))),
Region, [MovieNumber],[MovieName])=BreakEvenDate,

MovieCollection)

Here I wanted to bypass Continents Field. So that the selection of Continent wont affect the result. But When I used it as shown below, it still changing the data based on Continent selection:

if(aggr({<Continent=>} max( {<Continent=>}
if(aggr({<Continent=>} max( {<Continent=>}
if(aggr({<Continent=>} max({<Continent=>}
date(ReleaseDate)), Region) = [ReleaseDate],

[MovieNumber])), Region) = [MovieNumber],

date(BreakEvenDate))),
Region, [MovieNumber],[MovieName])=BreakEvenDate,

MovieCollection)

Then I used Only() Function on the top of the above expression, then bypassing was working as expected but the final result of MovieCollection data was getting changed.

I want to know whether it is possible to bypass Continent field using some other way apart from Only() function

Regards,
Aatish

Labels (2)
0 Replies