Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Highlight the listbox

Hi All,

I am using Qlikview 10 personal edition.

Can anyone please help me to highlight the listbox.

Let me explain you my task..

I have developed one report in qlikview. Now the task is suppose I am clicking in one field it will show the related fields. I need to highlight all those related fields including it.

Thanks in Advance.

1 Solution

Accepted Solutions
its_anandrjs

Hi Sandeepa,

See the attached sample where i give condition to the straight table which gives the null value highlighted in the red background by sinple condition to check null values. It is a chart which display the null values in any data.

Regards,

Anand

View solution in original post

12 Replies
sridhar240784
Creator III
Creator III

Hi,

Didn't get your question properly. You want the related data to be highlighted ? if so it is already highlighted by "Related item for the selection are in White" and data which is "Unrelated to the selection are in Gray"

Please explain you scenario in brief.

- Sridhar

Not applicable
Author

Is there anything like conditional format ?

If yes then please explain how to implement it...

Not applicable
Author

Yeah.. Your absolutely right...

It's highlighting in white color, is there any provision to change this color to any other color...

sridhar240784
Creator III
Creator III

As far as i know, there is no predefined option to change this default colors.

- Sridhar

sridhar240784
Creator III
Creator III

As far as i know, there is no predefined option to change this default colors.

- Sridhar

Or
MVP
MVP

When I last asked this question, I received a response that you cannot change QlikView's default selection colors (white for possible, gray for excluded, green for selected, blue for locked), and the same thing appears in QlikView 10's help file. You can play with the shades of these colors using the preset themes, but that's it.

What you might be able to use here is a List Box expression, perhaps set up as a stoplight gauge (see below image for example). This was achieved by adding a listbox expression with the formula along the lines of If(count(distinct myColumn)>0,1) and a stoplight gauge with a single light set to yellow.

Hope this helps,

Or

ListBoxHighlightSample.png

its_anandrjs

Hi,

You need to set aome setting in Properties -> Selection Style Override -> and set as on of Windowscheckbox or LED and see the changes.

Regards,

Anand

Not applicable
Author

Let me explain you in brief..

When I am clicking on one field the related fields are populating. Some fields are null. I have to populate those null fields in a specific color which will be easier to identify for the end user.

Not applicable
Author

In ListBox properties there is an option called "Conditonal". I guess it may help. But do not know how to use it..

I have to highlight those fields which have null values.

Suppose by clicking on x,

a,b,c,d,e,f,g,h fields are populating. b,e,h fields have null values then I have to highlight in red.