topic Re: Set Analysis help in QlikView

Set Analysis help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Set Analysis help

sunny_talwar — Thu, 08 Sep 2016 12:36:55 GMT

May be this:

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

Re: Set Analysis help

HirisH_V7 — Thu, 08 Sep 2016 12:57:08 GMT

Hi,

Check this,

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

HTH,

Hirish

Re: Set Analysis help

Anonymous — Thu, 08 Sep 2016 13:05:18 GMT

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')))

Re: Set Analysis help

HirisH_V7 — Thu, 08 Sep 2016 13:25:10 GMT

Its working as you desired right!!

Re: Set Analysis help

Anonymous — Thu, 08 Sep 2016 13:40:00 GMT

Yeah, But I am getting Out Of Obj Memory error

Re: Set Analysis help

HirisH_V7 — Thu, 08 Sep 2016 13:55:09 GMT

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