topic Re: RGB Issue help please in QlikView

RGB Issue help please

Wed, 25 Nov 2020 16:16:04 GMT

I have these 6 columns with R,Y,G,C,NA.

I have to pick the least indicator meaning if one row has

G,Y,G Pick G

Y,G Pick Y

R,G Pick R

Y,Y,G Pick Y

NA,G,C Pick C

R,Y,G,C pick C

But if any row has C in it pick C.

How can I do this ?

sunny_talwar — Wed, 16 Mar 2016 15:47:16 GMT

May be RangeMinString() function:

RangeMinString(Direct, Legal, Indirect, Company)

Wed, 16 Mar 2016 15:57:06 GMT

That is for the alphabetical range A,B,C right..I need the range in Red ,yellow,green,complete where Complete is max and Red is least

Gysbert_Wassenaar — Wed, 16 Mar 2016 15:57:19 GMT

If(match('C',Direct, Legal, Indirect, Company),

'C',

if(Len(Trim(Direct)),

Direct,

If(Len(Trim(Legal)),

Legal,

If(Len(Trim(Indirect)),

Indirect,

Company))))

sunny_talwar — Wed, 16 Mar 2016 16:19:07 GMT

May be assign numeric values to these terms using Dual function and then use RangeMin() to make it work.