topic Re: Highlight the listbox in QlikView

Highlight the listbox

Tue, 16 Aug 2011 09:00:08 GMT

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.

Re: Highlight the listbox

sridhar240784 — Tue, 16 Aug 2011 09:11:07 GMT

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

Re: Highlight the listbox

Tue, 16 Aug 2011 09:47:50 GMT

Is there anything like conditional format ?

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

Re: Highlight the listbox

Tue, 16 Aug 2011 10:04:30 GMT

Yeah.. Your absolutely right...

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

Re: Highlight the listbox

sridhar240784 — Tue, 16 Aug 2011 10:29:14 GMT

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

- Sridhar

Re: Highlight the listbox

sridhar240784 — Tue, 16 Aug 2011 10:29:35 GMT

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

- Sridhar

Re: Highlight the listbox

Or — Tue, 16 Aug 2011 10:31:29 GMT

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,

Re: Highlight the listbox

its_anandrjs — Tue, 16 Aug 2011 10:49:01 GMT

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

Re: Highlight the listbox

Tue, 16 Aug 2011 11:00:32 GMT

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.

Re: Highlight the listbox

Tue, 16 Aug 2011 11:15:54 GMT

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.

Highlight the listbox

Or — Tue, 16 Aug 2011 13:09:26 GMT

This doesn't sound like a job for listboxes - why not use a Table or Chart (Straight Table / Pivot Table) object?

Re: Highlight the listbox

Wed, 17 Aug 2011 14:56:59 GMT

Now I have created the straight box..

Here where I have to apply the condition and where exactly to highlight where the field is null.

Re: Highlight the listbox

its_anandrjs — Fri, 19 Aug 2011 14:10:08 GMT

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