Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor II

Bar chart coloring scheme with a fomula

Hey Guys,

I have a small problem concerning my bar Charts, Im visualizing a variable bar Chart, that gets ist definition of the variable from a Dropdown menu. Within the Bar Chart, Im visualizing the values of a peer and a peer Group( which have been selected Prior) over the past 5 years concerning a variable KPI. This is the formula i used for one of my bar Charts: sum({<Jahr={$(vyears_1on1)},$(vscatterpeeronly)>+<Jahr={$(vyears_1on1)},$(vscatterpgonly)>}[$(one_on_one_1)])/$(one_on_one_dim_1) . My Intention is to Color al Peer bars in blue and all Peer Group bars in Grey. Therefore, I worked with the folowing formula: IF(Only({$(valternatestatepeerdia)} Firmenname) > 0,RGB(0,94,184), if(Only({$(valternatestatepgdia)} Firmenname) > 0, RGB(192,192,192))) 

Attached you will find a Screenshot of how the barchart currently Looks.

Screenshot (1).png

I would be very thankful for every single hint thats you guys can provide,

Kind regards,

Max