Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help in Colormix function

Hello Everybody,

I have used colormix function in Grid Chart, put the upper limit, Intermediate limit and lower limit but it's not working I guess.

The colors are same for the entire chart.

Could anyone please help me.

Please find the attached sample.

Thanks in Advance.

Sonali

1 Solution

Accepted Solutions
jagan
MVP
MVP

Hi,

Try like this

=Pick(Match(Criticality, 'High', 'Medium', 'Low'), RGB(90, 0, 0), RGB(150, 0, 0), RGB(255, 0, 0))

Regards,

Jagan.

View solution in original post

5 Replies
jagan
MVP
MVP

Hi,

Give this as Background expression

RGB(Mod(FieldIndex('Application Name', [Application Name]) * 80, 255) , Mod(FieldIndex('Application Name', [Application Name]) * 120, 255), Mod(FieldIndex('Application Name', [Application Name]) * 200, 255))

Hope this helps you.

Regards,

jagan.

Not applicable
Author

Hi Jagan,

Thanks for your reply.

It's working but what I need is If the Category of the Application is High then the color should dark , if it is Medium the color should lighter and if it is Low then it should be more lighter.

Basically I want the color should be Dark- Lighter-Lighter like we have in Heat Map.

Thanks

Sonali

jagan
MVP
MVP

Hi,

Try like this

=Pick(Match(Criticality, 'High', 'Medium', 'Low'), RGB(90, 0, 0), RGB(150, 0, 0), RGB(255, 0, 0))

Regards,

Jagan.

View solution in original post

Not applicable
Author

Hi Jagan,

Thanks for your help. It is working as expected.

One more question I want to ask. Could you please tell me how to change the size means if the criticality is high then the object  should be bigger if it is medium then it should be smaller and if it is Low then it should be smaller.

Thanks

Sonali

Not applicable
Author

Hi Jagan,

I have added one more field called score sum(score) is working fine with the size.

Thanks for your help.