Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ListBox color

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.

1 Solution

Accepted Solutions
engishfaque
Specialist III
Specialist III

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

View solution in original post

10 Replies
Not applicable

It can be solved only by macro.

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

Please help with code.

engishfaque
Specialist III
Specialist III

Dear Saurabh,

Kindly, find attached qvw.

Kind regards,

Ishfaque Ahmed

qlikoqlik
Creator II
Creator II

Hi

see the below thread you will get an idea

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

Thanks

Padma

bill_markham

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.

Not applicable

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

Can you send me the snapshot or image.

Thanks.

bill_markham

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() )

engishfaque
Specialist III
Specialist III

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

Not applicable

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.

Not applicable

How to use nogreen.css?