How to give colour in scatter cart in code?

[#1]

How to give colour in scatter cart in code?

I have a data :

TIME_LOG_IN       Color

08:00                    Green

08:15                    Yellow

08:40                    Yellow

09:40                    Yellow

10:10                    Red

Where i must insert expression color? I have a longitude and latitude. The Min(Time) is Green and Max(Time) is Red.

Can someone to help me?

[#2]

Hi,

Can you please specify X and Y axis of the chart?

Or attach a sample qvw file.

Br,

Neha

[IAMDV]

Danny - Like Neha mentioned, It will be great if you can post sample QV file. Meanwhile I'm sharing a video on Loading Colours within QlikView Script. I had created this video sometime back. I hope this helps!

http://qlikshare.com/41

Cheers - DV

[#4]

I have upload the qvw sample. Can someone help me to make right code?

Thanks

[subin6600]

It is prompting for username & password. Is it having any access restrictions to the report?

BR

Subin

[#6]

This is my code :

=if(Aggr(Min(TIME_LOG_IN), SALESREP_ID, YEAR_TRX, MONTH_TRX, DAY_TRX), RGB(0,255,0),

if(Aggr(Max(TIME_LOG_IN), SALESREP_ID, YEAR_TRX, MONTH_TRX, DAY_TRX), RGB(255,0,0),

RGB(255,255,0)))

Why can this code find minimum time but it can't find maximum time? It can't show red color.

Can someone help me if my code is wrong.

Thanks