topic Re: How to use colour symbols in the data in QlikView

How to use colour symbols in the data

Wed, 27 May 2015 09:02:57 GMT

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

Re: How to use colour symbols in the data

buzzy996 — Wed, 27 May 2015 09:14:48 GMT

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())))

Re: How to use colour symbols in the data

alexandros17 — Wed, 27 May 2015 09:17:25 GMT

this is my example

Re: How to use colour symbols in the data

Wed, 27 May 2015 09:23:14 GMT

Hi Alessantro

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

Thanks

Smriti

Re: How to use colour symbols in the data

alexandros17 — Wed, 27 May 2015 09:25:23 GMT

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)
)
)
)

Re: How to use colour symbols in the data

awhitfield — Wed, 27 May 2015 09:26:10 GMT

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

Re: How to use colour symbols in the data

Wed, 27 May 2015 11:55:04 GMT

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.

Re: How to use colour symbols in the data

buzzy996 — Wed, 27 May 2015 12:03:07 GMT

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

Load

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)))

Re: How to use colour symbols in the data

ankit777 — Wed, 27 May 2015 12:08:54 GMT

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.

Re: How to use colour symbols in the data

Wed, 27 May 2015 12:11:35 GMT

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/

Re: How to use colour symbols in the data

Anonymous — Wed, 27 May 2015 12:13:02 GMT

Hi,

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

Regards,

Greeshma

Re: How to use colour symbols in the data

Wed, 27 May 2015 12:25:23 GMT

Hi Greeshma

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

Re: How to use colour symbols in the data

Anonymous — Wed, 27 May 2015 12:26:26 GMT

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.

Re: How to use colour symbols in the data

buzzy996 — Wed, 27 May 2015 12:28:23 GMT

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

Re: How to use colour symbols in the data

Wed, 27 May 2015 12:31:47 GMT

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

Re: How to use colour symbols in the data

Anonymous — Wed, 27 May 2015 12:32:48 GMT

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

Re: How to use colour symbols in the data

Wed, 27 May 2015 12:39:15 GMT

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

Re: How to use colour symbols in the data

buzzy996 — Wed, 27 May 2015 13:08:15 GMT

two things,

1.just replace tis with ur script,

Load

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)))

Re: How to use colour symbols in the data

Wed, 27 May 2015 13:23:05 GMT

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?

Re: How to use colour symbols in the data

buzzy996 — Wed, 27 May 2015 13:51:22 GMT

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