topic Re: Need help in Colormix function in QlikView

Need help in Colormix function

Tue, 23 Sep 2014 06:57:07 GMT

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

Re: Need help in Colormix function

jagan — Tue, 23 Sep 2014 07:29:32 GMT

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.

Re: Need help in Colormix function

Tue, 23 Sep 2014 07:37:47 GMT

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

Re: Need help in Colormix function

jagan — Tue, 23 Sep 2014 07:54:53 GMT

Hi,

Try like this

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

Regards,

Jagan.

Re: Need help in Colormix function

Tue, 23 Sep 2014 08:06:35 GMT

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

Re: Need help in Colormix function

Tue, 23 Sep 2014 08:24:22 GMT

Hi Jagan,

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

Thanks for your help.