How to use colour symbols in the data

[#1]

Hi community

I am trying to create a dashboard on SLA where I rate my SLAs into high priority, medium priority and low priority. each identified by a colour symbol. And in my data within qlikview which shows the SLA, those colour symbols should reflect, as shown in the attached excel.

Regards

Smriti

[buzzy996]

i think u have to try with simply if condition on ur sla expression,

like,if (urslaexpre>90,rgb(ur color with number u have mention here like,255,200,155),

      if (urslaexpre>60,rgb(),

     if (urslaexpre<60,rgb())))

[alexandros17]

this is my example

[#4]

Hi Alessantro

I am working on personal edition. So cannot open your file. Can you copy and paste your example here.

Thanks

Smriti

[alexandros17]

Simply I created a table.

LOAD * Inline [
Field1
1
2
3
4
5
6
7
8
9
];

and an expression where the backgroubd colour has the following expression

If(Field1 >=1 and Field1<=3, RGB(255,0,0),
If(Field1 >=4 and Field1<=6, RGB(128,0,0),
If(Field1 >=7 and Field1<=9, RGB(128,128,0)
)
)
)

[awhitfield]

Hi,

use a 'blank' expression with a conditional 'if' background colour, see simple example attached, that has

If(Priority = 'High', RGB(255,0,102),
if(Priority='Medium',RGB(255,95,159),RGB(255,175,207)))

You need to experiment with the RGB values, to got the required colour.

HTH Andy

[#7]

Hi

I tried both of your solutions. But my dashboard is not coming as the  screenshotword file I have  attached the the word file I have attached in the beginning.. I am attaching the qvw file for your reference Can you point out the mistake I am doing.

[buzzy996]

just replace tis part of code & reload..and see?

Load

T,

If (T =1, RGB(255,0,0),

If (T=2 , RGB(128,0,0),

If (T =3, RGB(128,128,0)

)

)

)  as Priority

ELSE USE THIS SIMPLY ON UR EXPRESSION,

If(T = '1', RGB(255,0,102),

if(T='2',RGB(255,95,159),RGB(255,175,207)))

[ankit777]

If T field denotes the priority, then promote T field to second position after case field an Dimensions.

And then add this expression for background color within this dimension

if(T=1,RGB(128,0,0),
if(T=2,RGB(128,128,0),
if(T=3,RGB(255,0,0))))
You will get the desired output as in screen shot.

[#10]

Thanks Shiva

I just tried this. I am getting the output as below qvw file. But instead of High, medium, Low in the column'priority', I want to replace this with colours. How to do this? I mean instead of High ,it should show dark red colour , instead of medion, light red and so on/