Do not allow selection in column correl

[qliker3]

so i have this formula to calculate the correlation in a column (i have multiple)

Correl(
Aggr( Sum( distinct prCount), [SNr], [Version], Time, Name),

Aggr( if(Duration <= Fractile(Total Duration, 0.99836), Duration), [SNr], Version, Name, Time))

i want this to ignore the selection in filter pane for the field "Path". I tried:

Correl(
Aggr( Sum( distinct {<Path = >} prCount), [SNr], [Version], Time, Name),

Aggr( if(Duration <= Fractile(Total Duration, 0.99836), {<Path = >} Duration), [SNr], Version, Name, Time))

but it didnt work. 

Could you please help me with fixing this? 

Thanks 

[tresesco]

Try putting the set componets in Correl() as well like:

Correl(  {<Path = >} 
Aggr( Sum( distinct {<Path = >} ...

[qliker3]

this did not help 

[tresesco]

I see you are putting set in if(... structure, that needs to be corrected. Try bringing that down to aggr(), like:

Aggr( {<Path = >} if(Duration <= Fractile(Total Duration, 0.99836),  Duration)

[qliker3]

still dosent work: 

Correl( {<Path = >} 
Aggr( Sum( distinct {<Path = >} prCount), [SNr], [Version], Time, Name),

Aggr( {<Path = >}  if(Duration <= Fractile(Total Duration, 0.99836), Duration), [SNr], Version, Name, Time))

[tresesco · Accepted solution]

Ohh, sorry you have another aggregation function, i.e - fractile. Put the set in that too and let me know.