topic ListBox color in QlikView

ListBox color

Tue, 02 Sep 2014 11:23:32 GMT

Hi,

I have a listbox and I want to change color of selected value to be either red or blue, not of complete list.

The complete list's color can be changed using macro but I want only a specific item to be highlighted(which is selected item) and other items not.

Re: ListBox color

Tue, 02 Sep 2014 11:25:56 GMT

It can be solved only by macro.

I think we will have to use if conditions in macro.

Please help with code.

Re: ListBox color

engishfaque — Tue, 02 Sep 2014 11:34:07 GMT

Dear Saurabh,

Kindly, find attached qvw.

Kind regards,

Ishfaque Ahmed

Re: ListBox color

qlikoqlik — Tue, 02 Sep 2014 11:36:44 GMT

see the below thread you will get an idea

http://community.qlik.com/thread/126742

Thanks

Padma

Re: Re: ListBox color

Anonymous — Tue, 02 Sep 2014 12:15:14 GMT

Saurabh

Do you know Deepak Sethia ?

He posted a pretty much identical thread a few hours ago, List Box

In my reply I frigged a Straight Table to act like a List Box and sort the colours using the Dimension Background / Text Color.

See attached.

You'll also see another object similar to the one you described in answer to Deepak.

Re: ListBox color

Tue, 02 Sep 2014 17:22:42 GMT

I am using personal edition so cant view your qvw file.

Can you send me the snapshot or image.

Thanks.

Re: Re: ListBox color

Anonymous — Tue, 02 Sep 2014 17:43:59 GMT

Create a Straight Table with just a Dimension of what was in the List Box.

For the Dimension Background Color expression use something like :

=if ( GetSelectedCount (Level) > 0 ,

if ( Level = 'Complaint' , red() ,

if ( Level = 'Compliment' , lightgreen() ,

if ( Level = 'Mixed' , yellow()) ) ) )

For the Dimension Background Color expression use something like :

=if ( Level = 'Complaint' , white() )

Re: ListBox color

engishfaque — Wed, 03 Sep 2014 05:52:00 GMT

Dear Saurabh,

You can change the listbox colour by using extension. Here is the current thread, have a look.

Re: Re: List Box

Kind regards,

Ishfaque ahme

Re: Re: ListBox color

Wed, 03 Sep 2014 10:50:52 GMT

For example if I am using ID of baseball players in dimension, then it is not showing in straight table as there need to be a expression too.

Tell me the way to do it by macro if possible by using if condition in macro.

Re: ListBox color

Wed, 03 Sep 2014 10:52:47 GMT

How to use nogreen.css?

Re: Re: ListBox color

engishfaque — Wed, 03 Sep 2014 11:29:47 GMT

Dear Saurabh,

Here are the steps,

Step 1:

Install the extension "NoGreen.qar".

Step 2:

Go to the Extension Folder Path, where extension will be install by defualt, here is the path for windows 7:

C:\Users\ashfaque_ahmad\AppData\Local\QlikTech\QlikView\Extensions\Document\NoGreen

Step 3:

Replace the "NoGreen.css" file in extension folder, "NoGreen.css" attached in this thread, please find.

Step 4:

Document Properties > Extensions > Add "NoGreen" to Active Extension > Apply > OK.

Step 5:

Close your qvw document and re-open. Now List Box selection color has been changed.

If need be, please let me know.

Kind regards,

Ishfaque Ahmed