Set Analysis help

[Anonymous]

Hi All,..

I need to convert the following If condition to Set analysis

=if(isnull(MaxString(INDICATOR)),0,

  if(Only({<HEALTH_INDICATOR={'Y'}>}HEALTH_INDICATOR)='Y', '1', '2'))

Facing issue in data load.

Can you help on this?

[sunny_talwar]

May be this:

RangeSum(Only({<HEALTH_INDICATOR = {'Y'}>} 1), Only({<HEALTH_INDICATOR -= {'Y'}>} 2))

[HirisH_V7]

Hi,

Check this,

If(isnull(MaxString(INDICATOR)),'0',
If(HEALTH_INDICATOR='Y','1','2'))

HTH,

Hirish

[Anonymous]

Hi Harish & Sunny,

Thanks for your quick reply. Actually my problem here is I am using the in built QVLEDs instead of Numbers.

Also in the table I dont have any null entires.In the pivot table I am finding the NULL values on the fly.If any of cells are NULL then I need to put grey lights.If  it is N then I am putting Green LEDs.If it is Y then I will put either Red.

My original exp like below

(if(isnull((INDICATOR)),'qmem://<bundled>/BuiltIn/led.png',

  if(Only({<INDICATOR={'Y'}>}HEALTH_INDICATOR)='Y', 'qmem://<bundled>/BuiltIn/led_r.png', 'qmem://<bundled>/BuiltIn/led_g.png')))

[HirisH_V7]

Its working as you desired right!!

[Anonymous]

Yeah, But I am getting Out Of Obj Memory error

[HirisH_V7]

Hi,

Check this,

If your are using

Only({<INDICATOR={'Y'}>}HEALTH_INDICATOR)

Can't say exactly, Check above expression ,placing in text box what its displaying by selecting required fields.

else ,

Please provide sample columns of your data and required output too.

-Hirish