Background Color Expression for cyclic Group.

[#1]

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

[#2]

Hi Jean,

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

As i tried but it is not working.

Thanks

[#3]

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

[#4]

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.

[#5]

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

JJ

[#6]

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.

[#7]

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.

[#8]

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

[#9]

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

[#10]

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

[#11]

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.