Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

background colour on condition

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

1 Solution

Accepted Solutions
sunny_talwar

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)

View solution in original post

6 Replies
sunny_talwar

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

imrencimen
Contributor III
Contributor III

can u prepeare qvw file with reduced data?

Not applicable
Author

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

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)

Not applicable
Author

Sunny, you are my hero. It works now.