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

[Anonymous]

Hi,

You need to add the colors in the expression and not in the script. Please see attached.

Regards,

Greeshma

[#3]

Hi Greeshma

I am using personal edition. So cannot open your file. If possible can you send me screenshots.

[Anonymous]

Are you trying to do this in a listbox? If so you can create images for high, medium and low. Add the expression in the Expression tab of list box and select representation as image. Refer to attached QVW.

[buzzy996]

hi.i think i u missed a bit code wht I SHARED above( myself modified that a bit when i was posted with in a mint),

please that. and see

missing T AFTER LOAD STMT

[#6]

Hi Greeshma

I am not able to open your qvw file since I am using a personal edition. So please send me the screenshots of your file.

And I want to do this in a list box and a straight table as well.

Smriti

[Anonymous]

If you want this in a chart, then follow Andrew's suggestion as shown above. If you need it in a list box, then create images for the 3 priorities and add below expression in the expression tab of your listbox

If(Priority='High,'image path for high', if(Priority ='Medium', 'image path for medium','image path for low'))

Regards,

Greeshma

[#8]

Hi Shiva

I have used the code as yours this time. Still  colours are not coming in priority field. Instead it is taking test. see the attached qvw

[buzzy996 · Accepted solution]

two things,

1.just replace tis with ur script,

Load

T,

If (T =1,'High',

If (T=2 , 'Medium',

If (T =3, 'Low'

)

)

)  as Priority

Resident Helpdesk;

2. on ur piriory dimension--background clor place tis,

If(Priority = 'High', RGB(255,0,102),

if(Priority='Medium',RGB(255,95,159),RGB(255,175,207)))

[#10]

Perfect......Thankyou so much.... The last thing I want to to is to reflect the same colours in my listbox also. I mean after priority, it should indicate whch colour is high, which is medium and which is low. How to do that?

[buzzy996]

use the expression on ur list box and put same expression shared earlier on list box..and see?