topic Highlighting lines in a table box in QlikView

Highlighting lines in a table box

Fri, 29 May 2009 23:58:49 GMT

Hi all,

Is there a way to highlight lines in a table box under certain criteria?

i.e i have the following table

Name Address Country

Lee street1 UK

Mike street2 UK

Mr. street3 IE

I would like to highlight all lines in, say, red if they do not have the country of UK

Thanks again

Mike

Highlighting lines in a table box

Sat, 30 May 2009 01:12:21 GMT

Yes. To highlight single fields based on the value of that field, look into Visual Cues.

For your purpose, you need to look at the additional attributes (I don't know what they're really called) under the Dimensions and Expressions. On the Dimension or Expression tab, your items should have a little plus next to them. Click on the plus and you should see some additional attributes. I don't know if you want to change the text color or the background color, but the concept is the same. Right-click on the attribute you want to change and choose Edit Expression. Here you can define a formula to define the color. You can use the function RGB(0,0,0) to define your colors.

=If(Country <> 'UK', RGB(255, 0, 0), RGB(0,0,0)

That would give Red if it's not the UK and Black if it is.

Highlighting lines in a table box

Anonymous — Sat, 30 May 2009 01:41:58 GMT

They're called attribute expressions.

Highlighting lines in a table box

Sat, 30 May 2009 01:45:44 GMT

+ symbol will not come on table box, it will come only on pivot table or straight table if i'm not wrong.

He wants to do in the Table box.

Thanks,

Raghu.

Highlighting lines in a table box

Sat, 30 May 2009 02:13:55 GMT

Thanks Michael. I was close.

Sorry, I missed the part about the request being for a table box. I agree, I don't think it is possible in a table box. Mike, is there a reason you need a table box rather than a straight table? I tend to always use straight tables (or pivots) when displaying data.

Are there any benefits to using a table box over a straight table?

Highlighting lines in a table box

Anonymous — Sat, 30 May 2009 02:23:21 GMT

Table boxes are quite limited, and they're even slower than sttaight tables. It's easy to create a table that looks the same as table box.

Highlighting lines in a table box

Wed, 03 Jun 2009 17:58:05 GMT

Hi all,

Just want to say thanks for the suggestions and I am trying to create a straight table which mimics the table box. I have never created a straight table, just a pivot table and I have added all my dimensions in but unsure what to use for expressions. If I don't enter an expression, it doesn't provide any data...

Using my example, what would I use as the expression?

Thanks,

Mike

Highlighting lines in a table box

Wed, 03 Jun 2009 18:03:20 GMT

In a straight table, if you really don't have an expression, just put an expression in like =1, then go to the presentation tab and hide it!

Nigel.

Highlighting lines in a table box

Wed, 03 Jun 2009 18:06:18 GMT

Oh yeah! doh!

Highlighting lines in a table box

Anonymous — Wed, 03 Jun 2009 19:23:34 GMT

Nigel,
Your suggestion to use =1 and hide it is certainly correct, but I can't agree with the statement that in a straight table you "don't have an expression". Straight table is no less functional than a pivot table or any other chart, just looks differently.
In fact, when a client wants a long table (many columns), my preference is to use a unique ID as a single dimension, which is hidden, and all other columns as expressions. If they are not calculated, I use expression only(fieldname). This provides better control over the layout.

Highlighting lines in a table box

Wed, 03 Jun 2009 19:34:07 GMT

Michael

Maybe you should read the statement again because you are missing a fairly key word.

My statement was: IF you really don't have an expression

Nigel.

Highlighting lines in a table box

Anonymous — Wed, 03 Jun 2009 20:53:57 GMT

Opps, sorry

Highlighting lines in a table box

Wed, 03 Jun 2009 21:02:16 GMT

now this is the thing that I don;t get...

I can set up all my dimensions into expressions (from what I can see, visual cues only apply to expressions) and when I place 1 unique dimension in, the output that comes doesn;t seem to be correct... maybe it's just me

Thanks again,

Mike

Highlighting lines in a table box

Anonymous — Wed, 03 Jun 2009 23:50:37 GMT

Mike,
It's not Visual Cues that you need to use, it's the attribute expressions. Go back to the first reply from NMiller, and just follow the instructions

Highlighting lines in a table box

Fri, 05 Jun 2009 17:44:33 GMT

Thanks to both NMiller and Michael for the help. Just to let you all know that this only changes the field colour not the whole line but I can always copy and paste!

Thanks again for al your help.

Mike