Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
tomgrouwe
Contributor III
Contributor III

Colors in barchart

Dear experts,

In my dashboard i have a barchart with a reference line that is set at 98%.

Is it possible that the barcolors in the barchart change, when the reference line is met or not? (Green 98% or >, Red or yellow when < than 98%)

1 Solution

Accepted Solutions
micheledenardi
Specialist II
Specialist II

HI Tom, something like this ?

2017-06-08 11_50_03-Proprietà Grafico [Sales].png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

7 Replies
prma7799
Master III
Master III

Can you please elaborate more? Or send some sample app

qlikviewnovice
Specialist II
Specialist II

Post Sample data

jonathandienst
Partner
Partner

It is possible. Set the background colour (click + next to the expression on the Properties | Expressions tab to get to these properties) to a conditional expression that sets the colour according to your requirements. Something like

    =If(Column(1) > 0.98, green(), red())

    or

    =If(<column expression here> > 0.98, green(), red())

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
micheledenardi
Specialist II
Specialist II

HI Tom, something like this ?

2017-06-08 11_50_03-Proprietà Grafico [Sales].png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
tomgrouwe
Contributor III
Contributor III
Author

Hello Michele,

That's exactly what I mean.

Siva_Sankar
Master II
Master II

Hi Tom,

It is possible. Find the attached example.

Capture2.JPG

micheledenardi
Specialist II
Specialist II

Hi Tom,

please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.