topic Background Color Expression for cyclic Group. in QlikView

Background Color Expression for cyclic Group.

Fri, 11 Dec 2009 13:02:25 GMT

Hi,

With cyclic group i am facing issue to get the correct color for the different bars even i mentioned proper Background color expression.

Does anybody have any idea how to specify the background color for different bars with cyclic Group.

Thanks

Background Color Expression for cyclic Group.

Fri, 11 Dec 2009 15:03:43 GMT

Hi Mansi,

Here you are a possible solution.

I hope this help you.

Best regards.

Background Color Expression for cyclic Group.

Fri, 11 Dec 2009 15:56:12 GMT

Thanks for the reply.

In the current QVW for country all Bars in same color and my reqirement is somewhat different. I need to specify specific color for specific value. As there are only 4 values of country.

I need the urgent help.

Thanks for the favour in advance.

Background Color Expression for cyclic Group.

Fri, 11 Dec 2009 16:04:54 GMT

Hi Mansi,

Could you be more especific with and describing what is your expected result based on my file?

Best regards.

Background Color Expression for cyclic Group.

Fri, 11 Dec 2009 16:25:54 GMT

Are you trying to have different colours for different groups or different colours for different expression values (same for all groups)?

Background Color Expression for cyclic Group.

Fri, 11 Dec 2009 17:02:38 GMT

Hi,

Please see the attached screen shots. In Country.bmp all countries have different specific colors.In Same way for all empid should be in different specific color. In the same way for Name.

Let me know if it is not clear to you.

Thanks in Advance.

Background Color Expression for cyclic Group.

Fri, 11 Dec 2009 17:14:54 GMT

Hi,

I want different colors for different Groups.

Thanks

Background Color Expression for cyclic Group.

Fri, 11 Dec 2009 17:34:54 GMT

hi,

Do you wanna specify every color for every value for every group with your particular selection of colors?

Best regards.

Background Color Expression for cyclic Group.

Sat, 12 Dec 2009 02:20:54 GMT

Hi Miguel,

I was also searching for the same requirement .Like I want to specify every color for every value for every group with particular selection of colors.

Please tell me how to implement this by modifying your above attached QVW file.

Regards

Background Color Expression for cyclic Group.

Sat, 12 Dec 2009 05:16:13 GMT

Add a new column in the scrip, here Numcol = color for each county

LOAD * INLINE [
EMPID, Name, Sal, Country , NumCol
1, A, 10, Spain , 6
2, B, 20, France , 12
3, C, 30, Spain, 6
4, D, 40, USA, 18
];

Then open the chart, go to expressions, clikc on +, go to background color and write color ( NumCol).

You have now a unique color t for each county.

regards

Background Color Expression for cyclic Group.

Mon, 14 Dec 2009 12:54:46 GMT

Hi Jean,

Can you please send me the sample QVW file for this?

As i tried but it is not working.

Thanks

Background Color Expression for cyclic Group.

Mon, 14 Dec 2009 14:11:56 GMT

Hi Miguel,

Yes, This is the same requirement which i need to implement.

Can you please modify your attached QVW file for this requirement?

Thnaks

Mansi

Background Color Expression for cyclic Group.

Mon, 14 Dec 2009 14:57:18 GMT

Hi Mansi,

Here you are the modificated example.

I've used the function rand for generating each color, but, you could write every one as constants if you want.

I hope this help you.

Best regards.

Background Color Expression for cyclic Group.

Mon, 14 Dec 2009 15:25:47 GMT

This is the same example with a constant instead of random.

Have a look also to the function RGB or ARGB in the reference guide to assign specific color.

regards

Background Color Expression for cyclic Group.

Mon, 14 Dec 2009 15:48:30 GMT

Hi Miguel,

I have updated this QVW file as per my current requirement using RBG for specific values for EMPIDColor,NameColor,CountryColor.

But mentioned color is not reflected. Can you please rectify me where i am worng.

Thanks in advance.

Background Color Expression for cyclic Group.

Mon, 14 Dec 2009 16:32:33 GMT

Hi Mansi,

here you are your mistake:

=if(GetCurrentField(Group) = 'Country', CountryColor, if(GetCurrentField(Group) = 'Name', NameColor, EMPIDColor))

Just remove the Color function.

Be carefull, the table name EmpIDColor is duplicated.

Best regards.

AW:Re: Background Color Expression for cyclic Group.

Mon, 14 Dec 2009 17:40:54 GMT

Hi,

you don't need the color function to specify the color, when you give them in RGB(x,y,z).

Use

=if(GetCurrentField(Group) = 'Country',CountryColor, if(GetCurrentField(Group) = 'Name',NameColor, EMPIDColor))

in the Formula for the Background color.

Have fun with QV

Alex:)

Background Color Expression for cyclic Group.

Mon, 14 Dec 2009 18:54:30 GMT

Hi Miguel,

I have created one new QVW file to implement the same requirement.

But it is not working. Please let me know what is the issue in it.

Please give me quick reply.

Thanks in Advance

Background Color Expression for cyclic Group.

Mon, 14 Dec 2009 18:56:13 GMT

Hi Miguel,

I have created one new QVW file to implement the same requirement.

But it is not working. Please let me know what is the issue in it.

It will be a great help if you can give quick reply. As i needed it urgently.

Thanks in Advance

Background Color Expression for cyclic Group.

Mon, 14 Dec 2009 19:02:43 GMT

Hi Mansi,

The values of field Req_Risk are: A-High, B-Medium and not Urgent, Very High, High like you've defined.

Best regards.