Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

How to make my same Brand color similar ?

Hi All

I have 2 field , one if core band another one is all brand.

When i try to use the color to represent each brand.

How to make both Brand=Hakko same color ?

Now they are different color.

Can some one share with me using expression.

For example

Hakko = Red

GE or GE Fanuc = Blue

Thank you.

Paul Yeo

1 Solution

Accepted Solutions
prma7799
Not applicable

Re: How to make my same Brand color similar ?

You can use below script in color expression

If(bRAND='HAKKO', lightRed(),If(bRAND='GE' Or bRAND='GE FANUC', lightBlue(),Green()))

4 Replies
ahaahaaha
Not applicable

Re: How to make my same Brand color similar ?

Hi,

Look attached file

Regards,

Andrey

prma7799
Not applicable

Re: How to make my same Brand color similar ?

You can use below script in color expression

If(bRAND='HAKKO', lightRed(),If(bRAND='GE' Or bRAND='GE FANUC', lightBlue(),Green()))

paulyeo11
Not applicable

Re: How to make my same Brand color similar ?

Hi Andrey & PM

it work now. Thank you.

Paul Yeo

prma7799
Not applicable

Re: How to make my same Brand color similar ?

Hello Paul Sir,

Please close this thread with marking helpful and correct answer.

Thanks

PM