Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Lucky1
Creator
Creator

Color based on letters starts

i have status field with values

status

Exams1

Exams2

Information1

Information2

 

i want to give green color which starts with Exams and i have to give black color value start with information

how to do that in my pivot table background color 

 

Exams* as Green()

Inf* as Black()

Labels (4)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

Try this 

if(Left(status, 5) = 'Exams', RGB(0, 255, 0),

if(Left(status, 10) = 'Information', RGB(0, 0, 0)))

 

Or 

if(Match(Left(status, 5), 'Exams*'), RGB(0, 255, 0),

if(Match(Left(status, 3), 'Inf*'), RGB(0, 0, 0))

)

View solution in original post

1 Reply
Chanty4u
MVP
MVP

Try this 

if(Left(status, 5) = 'Exams', RGB(0, 255, 0),

if(Left(status, 10) = 'Information', RGB(0, 0, 0)))

 

Or 

if(Match(Left(status, 5), 'Exams*'), RGB(0, 255, 0),

if(Match(Left(status, 3), 'Inf*'), RGB(0, 0, 0))

)