topic Re: background colour on condition in QlikView

background colour on condition

Mon, 04 Apr 2016 14:51:43 GMT

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

Re: background colour on condition

sunny_talwar — Mon, 04 Apr 2016 14:55:19 GMT

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

Re: background colour on condition

imrencimen — Mon, 04 Apr 2016 14:58:09 GMT

can u prepeare qvw file with reduced data?

Re: background colour on condition

Mon, 04 Apr 2016 15:03:03 GMT

yes of course. sorry.

assetline_doclinenum is in the first table column doclinenum.

and doclinenum is the column doclinenum from the second table.

Re: background colour on condition

marcus_sommer — Mon, 04 Apr 2016 15:04:59 GMT

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

Re: background colour on condition

sunny_talwar — Mon, 04 Apr 2016 15:08:14 GMT

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)

Re: background colour on condition

Mon, 04 Apr 2016 15:20:25 GMT

Sunny, you are my hero. It works now.