Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

RGB Issue help please

EscFollowDirectLegalIndirectCompany
G
Y
C G
C Y
G G
G Y
GYG
Y G
YYG

NAG C

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 ?

4 Replies
sunny_talwar

May be RangeMinString() function:

RangeMinString(Direct, Legal, Indirect, Company)

Not applicable
Author

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

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

     'C',

     if(Len(Trim(Direct)),

          Direct,

          If(Len(Trim(Legal)),

               Legal,

               If(Len(Trim(Indirect)),

                    Indirect,

                    Company))))


talk is cheap, supply exceeds demand
sunny_talwar

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