Comparing Text in two columns of a Chart

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

I have a single chart with columns in alternate states. I am using a formula to highlight cells in yellow when the value in the two states do not match. This formula is:

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

This formula works great in the background color function of the expression when the value is a number. However when the value is text, it does not work. I think it has to do with it having "sum" but the expression fails when I delete it. Any idea on what I can put it in place to make the expression work for text?

Re: Comparing Text in two columns of a Chart

sunny_talwar — Wed, 28 Mar 2018 19:05:55 GMT

May be use Only()

=If((Only({[Chart 1]} Group)) <> (Only({[Chart 2]} Group)), yellow())

Re: Comparing Text in two columns of a Chart

Anonymous — Wed, 28 Mar 2018 19:09:16 GMT

That worked! Thank you very much Sunny!

topic Comparing Text in two columns of a Chart in QlikView

Comparing Text in two columns of a Chart

Re: Comparing Text in two columns of a Chart

Re: Comparing Text in two columns of a Chart