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

[mohan_1105]

Hi Qliker,

Do we have any help..!!!

[sunny_talwar]

Nullify? What exactly are you trying to nullify here? I am not entirely sure I understand

[mohan_1105]

Hi Sunny,

I wanted to make the expression static when the user select "Header" field. So I have included the field disabling function as you could see in my expression {<Header= >}. 

Even after I added the field as mentioned above, the "Header" field is interacting with the chart.

Regards,

Mohan

[Vegar]

When writing something like ...
"Green_Ind" = '≤'
...in an expression you are actually saying...
Only("Green_Ind") = '≤'
...which is not an "nullified" expression. Try changing them into an only aggregations with a SET like this:
Only({<Header=>}Greek_Ind") = '≤'

[jonathandienst]

In addition to the above, did you try to remove Header from the list of Aggr() dimensions?

[mohan_1105]

Hi Vegar,

I tried it as you suggest but there is no luck.. 

I have attached the sample application so you could understand the expression better...

[mohan_1105]

Hi jonty,

You are correct the Header isn't required in Aggr()..

Thank you..!!

Regards,

Mohan

[Vegar]

@mohan_1105 Did the last comment of @jonathandienst solve your issue?

[mohan_1105]

Nope... It all same even after removing the "Header" field from the expression.