Please see the attached files for clarity,
I have two excel files(Colour and Benchmark), The Colour excel file has Names and Amounts and The Benchmark have names and Benchmarks.
So in my colour coding Table on the Qlikview file, I calculated the TotalAmount of each person.
So to do the colouring, I am compering If Name in the Colour excel file match with BenchmarkName in the Benchmark excel file, and again check if TotalAmount I calculated is less than Benchmark in the benchmark excel file, the assign Red if TotalAmount is less or Green if TotalAmount is more than Benchmark, using this Expression: IF((xName = xBenchmarkName) and (TotalAmount < xBenchmark), Red(), Green())
So what I need is the way to exclude the columns where the Name and BechmarkName do not match and only return back the columns where they match in my table. The Total Amount table in qlikview file is just an example of how I want the Colour code table to look like.
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
.png "Luminary Alumni"){kind=icon}