Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Set Analysis help

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?

6 Replies
Highlighted

May be this:

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

Highlighted
Master
Master

Hi,

Check this,

If(isnull(MaxString(INDICATOR)),'0',

If(HEALTH_INDICATOR='Y','1','2'))

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Highlighted
Creator II
Creator II

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

Highlighted
Master
Master

Its working as you desired right!!

HirisH
“Aspire to Inspire before we Expire!”
Highlighted
Creator II
Creator II

Yeah, But I am getting Out Of Obj Memory error

Highlighted
Master
Master

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



HirisH
“Aspire to Inspire before we Expire!”