visual Cues Question

saurabh5 — Fri, 19 Jun 2015 15:10:31 GMT

Hi All,
I am trying to put colors in place of the values in the crosstab but some how its not working for me
Very High    red
High             orange
Moderate   yellow
Low             green
N/A             grey

My current expression is
= if (isnull(sum(rank)/(count(DISTINCT(UniqueID)))),'N\A',
if(sum(rank)/(count(DISTINCT(UniqueID)))<3.00,'Low',
       if(sum(rank)/(count(DISTINCT(UniqueID)))<6.00,'Moderate',
          if(sum(rank)/(count(DISTINCT(UniqueID)))<12.00,'High',
            if(sum(rank)/(count(DISTINCT(UniqueID)))<16.00,'Very High')))))

And my script is

Test:
LOAD * INLINE [
    Region, Country, Organization, rank, owner
    1, A, East, 2, peter
    2, B, West, 4, Sam
    3, C, NorthEast, 8, Alex
    4, D, WestCost, 12, Wallen
    5, E, North, 8, Dona
    6, F, South, 2, Ben
    7, G, SouthWest, 2, Tina
    8, H, South, 4, Ben
    9, I, West, 8, Sid
    10, J, WestCost, 8, Wallen
];

Test2:
NoConcatenate
load * ,
Region&'-'&Country as UniqueID
Resident Test;

drop Table Test;

Re: visual Cues Question

giakoum — Fri, 19 Jun 2015 15:17:16 GMT

see attached

Re: visual Cues Question

saurabh5 — Fri, 19 Jun 2015 15:32:55 GMT

Thanks,

It worked perfectly for my application.

Regards

Saurabh

topic Re: visual Cues Question in QlikView

visual Cues Question

Re: visual Cues Question

Re: visual Cues Question