topic Re: color coding in QlikView

color coding

Tue, 25 Feb 2014 09:33:52 GMT

Hi All,

i need to change the color for region which is having sale below 300000 should be shown in red others in green PFA

Regrads,

Nagaraju

maxgro — Tue, 25 Feb 2014 09:37:02 GMT

in your first expression, background color, expression

if(sum(sales) < 300000 , red(), green())

see attachment

MK_QSL — Tue, 25 Feb 2014 09:37:07 GMT

Go to expression tab

ON Longitude click on + sign and under background color write below expression..

IF(SUM(sales)<300000, RED(), GREEN())

Tue, 25 Feb 2014 09:41:42 GMT

Hi Manish,

Here in my map i am not able to show California in my map can u please help me

Tue, 25 Feb 2014 09:43:53 GMT

Hi Guys,

Actually my requirement is to show heat map how can i acheive that

amit_saini — Tue, 25 Feb 2014 09:44:04 GMT

Hi Kannuri,

Please find the attachment.

Thanks,

MK_QSL — Tue, 25 Feb 2014 09:45:52 GMT

You have wrong longitude for California...

It should be something like below..

Lat 37.072710

Long -117.106934

Tue, 25 Feb 2014 09:56:35 GMT

manish,

Can you please help me how can get the same as heat map