topic Re: Background color based on possible values in QlikView

Background color based on possible values

Anonymous — Tue, 28 Jun 2011 06:59:49 GMT

Hi!

I have a list of names, a high score list (in a list box with expressions), where each name also blongs to a group. I want to have a different background color in my highscore-list based on the different groups the names belongs to. One person can only belong to one group.

Please help. Thanks!

Background color based on possible values

kaushiknsolanki — Tue, 28 Jun 2011 07:06:00 GMT

Hi,

Background color to the cells in listbox is not possible(As far as i Know).

But you can achieve this in chart.

After Adding Expression in chart, click on + next to the expression you added.

You have a background color Option there.

Regards,

Kaushik Solanki

Re: Background color based on possible values

Anonymous — Tue, 28 Jun 2011 07:07:05 GMT

Not sure if you can modify the colors that much in a listbox.

Here's an ugly example using a straight table.

Background color based on possible values

Anonymous — Tue, 28 Jun 2011 08:18:47 GMT

for some reson i can't download the application. weird.

can't you post the expression? that's the one i'm having trouble with.

thanks!

Background color based on possible values

Anonymous — Tue, 28 Jun 2011 14:11:31 GMT

I figured it out using concat for the field i was looking for with possible values.

Like this:

if(concat(Group,'')='GroupName', RGB(255,0,0), RGB(0,0,0))