topic Re: How to display column values in colours in QlikView

How to display column values in colours

Thu, 13 Feb 2014 15:17:19 GMT

Hi,

I have a expression in straight table as below

DueDays= = today()-aggr(Date(max(DateDue)),ID)

and the values in that column are

1,975

2,098

1,897

-20

-13

-21

and so on

I would to show The minus values with RED colour and the rest with BLACK. Is this possible?

Thanks.

Re: How to display column values in colours

jerem1234 — Thu, 13 Feb 2014 15:20:04 GMT

Yep, check the + next to your expression, then under Text Color, put an expression like:

if(DueDays<0, red(), black())

Hope this helps!

Re: How to display column values in colours

Thu, 13 Feb 2014 15:24:04 GMT

Thanks and I need to show the RED colour as VERY Dark RED is it possible?

Re: How to display column values in colours

simondachstr — Thu, 13 Feb 2014 15:25:28 GMT

Get the RGB code for your DARK red and replace red() with RGB(redval,yellowval,blueval)

Re: How to display column values in colours

Thu, 13 Feb 2014 15:26:23 GMT

Thanks. I don't have RGB code for DARK red that is my problem.how to do this?

Re: How to display column values in colours

jerem1234 — Thu, 13 Feb 2014 15:27:07 GMT

Yep thats possible, you can use the rgb() function instead of red(). So find the rgb values for the color you want then fill them in the rgb function:

For example:

rgb(100,100,100) will show grey.

Hope this helps!

Re: How to display column values in colours

Thu, 13 Feb 2014 15:28:53 GMT

How can I get rgb() for DARK red as I don't have the code

Re: How to display column values in colours

jerem1234 — Thu, 13 Feb 2014 15:30:06 GMT

to find the rgb value, you can go to color tab and click one of the colors and then in the next window, click the window again. Then you can play around and see what colors give what rgb value (which is shown on bottom right as Red, Green, Blue).

A dark red color is:

rgb(140,0,0)

Hope this helps!

Re: How to display column values in colours

Thu, 13 Feb 2014 15:33:49 GMT

Thanks and this is working.

Re: How to display column values in colours

Thu, 13 Feb 2014 15:38:09 GMT

Can I know what is Pie Popout and Text format ? when I opened plus sigh I can able to see these.

Re: How to display column values in colours

jerem1234 — Thu, 13 Feb 2014 15:44:19 GMT

Pie Popout is for Pie charts, here is a snippet from Qlikhelp:

Pie Popout

Click on the Pie Popout in order to enter an attribute expression for calculating whether the pie slice associated with the data point should be drawn in an extracted "popout" position. This type of attribute expression only has effect on pie charts.

Also Text Format can format your text with bold, italic, and underline:

Text Format

Edit the Text Format expression to enter an attribute expression for calculating the font style of text associated with the data point (For tables: text in the table cell for each dimension cell. The calculated text format will have precedence over table style defined in the Chart Properties: Style.) The expression used as text format expression should return a string containing a '' for bold text, '' for italic text and/or '' for underlined text. Note that = is necessary before the string.

Hope this helps!

Re: How to display column values in colours

Thu, 13 Feb 2014 15:46:26 GMT

Thanks and this is good.

Suppose if I want to display

$20,£24,£27 and so on in Black colour. and $0 as 'Cancelled'(i, e in text). How can I get this?

Re: How to display column values in colours

jerem1234 — Thu, 13 Feb 2014 15:51:08 GMT

To represent 0$ as 'Cancelled', you'll need to actually put that into your main expression like:

If(sum(FIELD)=0, 'Cancelled', sum(FIELD))

Then if you want only positive values black, negative red, put the expression into text color:

IF(FIELD<0, rgb(140,0,0), black())

Hope this helps!

Re: How to display column values in colours

Thu, 13 Feb 2014 15:55:53 GMT

Yes you are right. Thanks

Re: How to display column values in colours

Thu, 13 Feb 2014 16:02:17 GMT

To change Text Format: I changed the Text Format But I haven't observed corrct expected change. can you please post some screens please

Re: How to display column values in colours

jerem1234 — Thu, 13 Feb 2014 16:07:20 GMT

Bold:

=''

Italic:

=''

Underline:

=''

Re: How to display column values in colours

Thu, 13 Feb 2014 16:11:14 GMT

That's really good thanks very much.

Can I ask in the same thread. I have Student Names from A to Z. Is it possible to change the colurs of the names starting with A as Green , B as Black and so on. I tried but semms not showing correct.

Re: How to display column values in colours

Thu, 13 Feb 2014 16:14:46 GMT

I used the below in dimension

=If(StudentName='A%',Green())

Re: How to display column values in colours

jerem1234 — Thu, 13 Feb 2014 16:19:07 GMT

You can use a formula like:

=pick(match(left(Student,1), 'A','B','C'), black(), green(), magenta())

or wildmatch:

=pick(wildmatch(Student, 'A*','B*','C*'), black(), green(), magenta())

Hope this helps!

Re: How to display column values in colours

Thu, 13 Feb 2014 16:21:35 GMT

Really Good!!!!!!