Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
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
I don't see assetline_doclinenum in any of the snapshots. Can you clarify where is that information coming from?
can u prepeare qvw file with reduced data?
yes of course. sorry.
assetline_doclinenum is in the first table column doclinenum.
and doclinenum is the column doclinenum from the second table.
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.
Sunny, you are my hero. It works now.