topic Re: Comparing two Columns in a the same Chart in QlikView

Comparing two Columns in a the same Chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a chart with two columns of data both using the same Fieldname but existing in different states.

The expressions are:

=Sum({[Chart 1]} Fieldname)

=Sum({[Chart 2]} Fieldname)

I am trying to write a expression under the background color box that would compare the number in both columns and highlight them in yellow if the are different. What I have written is below. The expression is OK but it is not showing up as yellow where it is different. Any idea on what is wrong in the expression?

=If(Aggr((Sum({[Chart 1]} [Addressable Spend])) <> (Sum({[Chart 2]} [Addressable Spend])), yellow())

Re: Comparing two Columns in a the same Chart

sunny_talwar — Thu, 13 Oct 2016 17:51:14 GMT

Why not just this:

If(Sum({[Chart 1]} Fieldname) <> Sum({[Chart 2]} Fieldname), Yellow())

Re: Comparing two Columns in a the same Chart

rupamjyotidas — Thu, 13 Oct 2016 17:51:21 GMT

Probably

if(Coumn(1)<>Column(2),Yellow())

Re: Comparing two Columns in a the same Chart

Anonymous — Thu, 13 Oct 2016 17:54:46 GMT

That worked perfectly. Thanks for your help!

Re: Comparing two Columns in a the same Chart

sunny_talwar — Thu, 13 Oct 2016 17:57:56 GMT

No problem at all... Happy to help