Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
Contributor II

visual Cues Question

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;

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: visual Cues Question

2 Replies
Highlighted
Partner
Partner

Re: visual Cues Question

Highlighted
Contributor II

Re: visual Cues Question

Thanks,

It worked perfectly for my application.

Regards

Saurabh