topic Expressions Background colouring in QlikView

Expressions Background colouring

Wed, 14 Mar 2012 09:30:26 GMT

Hi can someone please help me out,

I have a table chart where I have calculated Total Sum and I want to out a background colour using an expression.

I have table B where I want to do a lookup for the expression, so the colours has to be assigned depending on the values that are on table B.

And this is the expression I am using: IF(Name = BenchmarkName and TotalAmount < Benchmark, Red(), Green())

Please see the attached file for more clearity

Thanks in advance

Edzi

Expressions Background colouring

eliran — Wed, 14 Mar 2012 09:41:35 GMT

You can try using the following:

if
(sum(Benchmark)<sum(Amount) and Name=BenchmarkName,Green(),red
())
or using set analysis
if(sum({<Name={BenchmarkName}>}Benchmark)<sum(Amount),Green(),red())

dddd

So, what your'e checking is if the benchmark sum is less then the amount sum conditional name=benchmarkname

I hope it helps,

Eliran.

Expressions Background colouring

Wed, 14 Mar 2012 10:07:50 GMT

Hi Eliran

Thanks for replying, First I want the expression to compare text field Name and text on field BenchmarkName then if the text is the same we assign coulour.

Regards

Edzi

Re: Expressions Background colouring

eliran — Wed, 14 Mar 2012 14:10:06 GMT

Hey Edzi,

Sorry, I missunderstood your question earlier.

Why not changing the benchname to name?

You want to assign each name it's benchmark, that is the most logic way to do it.

Does it make sense to you?

Eliran.

Edit: I have attached an example.

Re: Expressions Background colouring

Thu, 15 Mar 2012 08:03:10 GMT

Hi Eliran

It was helpful though it was not 100% what I needed, I managed to get it working though only with a little problem, I want everything in Colour Coding Table chat to be grouped as in Total Amount Table chart.

Please see the attached file.

Kind regards

Edzi

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful