topic Re: Bar background color issue with current selections in QlikView

Bar background color issue with current selections

tatipelli14 — Sat, 16 Nov 2024 01:14:01 GMT

Hi group, I have a requirement where I have to color the bar based on dimension value picking from another field which is working fine. But when other field selections are made, this condition doesn't work.

Based on the data model, I am attaching a sample dashboard here. Anyone faced similar issue?

Re: Bar background color issue with current selections

_ylc — Mon, 02 Mar 2020 01:01:32 GMT

Based on your model, Customer #2 isn't associated with any Report Number. So If you select a report number, lets say 1, the Customer Name 2 is null.

Your color expression:

=if(Only({<[Report Number]=>}[Customer Name])=Only([Customer Name 2]), Green(), Red())

Customer Name: Cust1

Report Number: 1

Customer Name: null

Cust1 <> null thus output is Red()

The 2nd part of your condition should also ignore the Report Number selection then it will not change.

=if(Only({<[Report Number]=>}[Customer Name])=Only({<[Report Number]=>}[Customer Name 2]), Green(), Red())

Re: Bar background color issue with current selections

Brett_Bleess — Wed, 25 Mar 2020 13:13:51 GMT

Did the partner post assist you in getting things working? If so, do not forget to return to your thread to close things out by using the Accept as Solution button on that post to give them credit for the help and let other Members know that worked. If you are still working on things, please leave an update with what you still need from us.

Regards,
Brett