topic Re: Highlight fields in table in QlikView

Highlight fields in table

Mon, 14 Sep 2015 13:16:11 GMT

Hi there,

I wonder if you can help,

I would like to highlight values in a table (without filtering the table).

So, for example, if I select customer 'John Smith', is it possible to highlight all orders made by John in a table?

I do not want to filter the whole table, rather just highlight the rows that are related to John Smith,

Thanks

Re: Highlight fields in table

tresB — Mon, 14 Sep 2015 13:19:02 GMT

See if this helps: Force selection in listbox

Re: Highlight fields in table

Anonymous — Mon, 14 Sep 2015 13:22:44 GMT

t do you mean, that you select John Smith

Selecting a field, the table reduces to those rows belonging to this field

so you would only see orders made by John Smith.

can you Elaborate more what you want?

Re: Highlight fields in table

Mon, 14 Sep 2015 13:35:27 GMT

Hi there,

no, I do not want to reduce the table fields. I only want to highlight those fields that are relevant to the customer that has been selected.

So with the below example, I still want to see all the data, but, i want 'john smith' records to be highlighted

Order ID Name

281 John Smith

282 Carl Smith

287 Joe smith

223 John Smith

Re: Highlight fields in table

petter — Mon, 14 Sep 2015 13:41:00 GMT

If you click on the + to the left of an expression in the expression tab or the + to the left of a dimension in the dimensions tab for you charts properties you will see background color and you can define a definition for it which could look like this:

If( Customer = 'John Smith' , Yellow(100) )

This will make a light yellow background color in the cells for that particular column when the "value" is 'John Smith'.

If you want to have this more interactive you can create an Input Box with the variable v.HightLight_Customer

and then modify the definition for the background color to this:

If( Customer = '$(v.HighLight_Customer)' , Yellow(100) )

This will allow you to write the name of the customer and get this customer highlighted ...

Re: Highlight fields in table

Mon, 14 Sep 2015 13:44:19 GMT

Thanks Petter,

Ideally I would like to be able to do this based on the search box.

So, if the client searches "John Smith" the entire dashboard should update with his details.

I need this particular pivot table to behave slightly differently, as it should just highlight rows (data should not alter).

So, is there a way to alter your expression to say "if dropdown box = "john smith" then highlight rows"

Re: Highlight fields in table

jonathandienst — Mon, 14 Sep 2015 13:53:34 GMT

You will have to modify the table expressions (and any calculated dimensions) to ignore the selection (so that the selection does not hide the other rows), then add a a style and/or colour expressions to the expressions

Override specific selections in your expressions with the set expression syntax =Sum({<Field1=, Field2=>} ....)

For the colour expression

=If(Wildmatch(Concat(Field1, '|'), '*' & Field1 & '*'), LightRed())

Now if selection(s) of Field1 is/are made, then the selected values will change from the default colour to light red.

This works if the selections are dimensions in the table, but may give odd results if the field with selections is not part of the dimensions or closely related to the dimensions.

Re: Highlight fields in table

Mon, 14 Sep 2015 14:00:49 GMT

Thanks Jonathan,

I think I am almost there.

I have added the highlighting as you suggest.

When the customer name is selected, I do not want the data shown to be reduced / changed - just the field highlighted.

However, if I were to select "location" then I would want the data updated in the table to show customers in 'London' and then 'John Smith's" records should be highlighted.

Any idea how to add that kind of logic?

Re: Highlight fields in table

Tue, 15 Sep 2015 09:40:10 GMT

Is anyone able to help?