How to nullify a field in aggr function

[mohan_1105]

Hi Qliker,

Nullification isn't working in my expression. The output of the expression is working as expected but I need to nullify a field.

Following is my expression:

sum({<Header=>}

Aggr(

if("Green_Ind" = '≤' and [Scored? (Y/N)]='Y' and sum({<Header=>}Deno) <> '0',
if(sum({<Header=>}Numerator)/sum({<Header=>}Deno/Divisor) <= avg({<Header=>}"Green"),1),

if("Green_Ind" = '≥' and [Scored? (Y/N)]='Y' and sum({<Header=>}Deno) <> '0',
if(sum({<Header=>}Numerator)/sum({<Header=>}Deno/Divisor) >= avg({<Header=>}"Green"),1)))

,Header,[Measure Title],KPI))

A doubt, can I nullify the field which is been used to aggregate the data?

Regards,

Mohan

[sunny_talwar · Accepted solution]

So, all you want is to ignore selection in Header field? Try this

count({<Header=>}
Aggr(

if(only({<Header=>}"Green_Ind") = '≤' and only({<Header=>}[Scored? (Y/N)])='Y' and sum({<Header=>}Deno) <> '0',
if(sum({<Header=>}Numerator)/sum({<Header=>}Deno) <= avg({<Header=>}"Green"), Only({<Header>}[Measure Title])),

if(only({<Header=>}"Green_Ind") = '≥' and only({<Header=>}[Scored? (Y/N)])='Y' and sum({<Header=>}Deno) <> '0',
if(sum({<Header=>}Numerator)/sum({<Header=>}Deno) >= avg({<Header=>}"Green"),Only({<Header>}[Measure Title]))))
 
,Header,[Measure Title],KPI))

[mohan_1105]

Hi Sunny,

Code work like a champ... Thanks, ton..!

Regrads,

Mohan.