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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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