background colour on condition

[#1]

Hi,

may someone of you can help me.

I used a condition for the Background colour.

=if(doclinenum = assetline_doclinenum, RGB(98,172,30))

It is working fine when I have only one line in the first table. But it is not working if I have more than one line.

What should be adapted in the condition ?

Thanks for your help in advance.

Chris

[sunny_talwar]

I don't see assetline_doclinenum in any of the snapshots. Can you clarify where is that information coming from?

[imrencimen]

can u prepeare qvw file with reduced data?

[#4]

yes of course. sorry.

assetline_doclinenum is in the first table column doclinenum.

and doclinenum is the column doclinenum from the second table.

[marcus_sommer]

The reason will probably be that there not unique field-values and no aggregations are used so that a query on field returned NULL. A very good explanation and alternative could you find here: Colors in charts.

- Marcus

[sunny_talwar · Accepted solution]

I don't have the data to test, but can you try this:

Aggr(If(doclinenum = assetline_doclinenum, RGB(98,172,30)), doclinenum, assetline_doclinenum)

[#7]

Sunny, you are my hero. It works now.