Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be this:
RangeSum(Only({<HEALTH_INDICATOR = {'Y'}>} 1), Only({<HEALTH_INDICATOR -= {'Y'}>} 2))
Hi,
Check this,
If(isnull(MaxString(INDICATOR)),'0',
If(HEALTH_INDICATOR='Y','1','2'))
HTH,
Hirish
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')))
Its working as you desired right!!
Yeah, But I am getting Out Of Obj Memory error
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