topic Change in Target Color based on Budget in Line Chart in App Development

Change in Target Color based on Budget in Line Chart

pradeep92 — Fri, 12 Jun 2020 11:33:32 GMT

Hello ,

Please find the code below.

Load * Inline [
KPI,Target,Budget,Quarter
Sales KPI,80,75,Q1
Sales KPI,80,78,Q2
Sales KPI,72,85,Q3
Sales KPI,78,80,Q4
];

I am trying to implement a line chart where the Budget (1st Measure ) should be blue always and the Target(2nd Measure)should be green if Budget is less than Target and Red if Budget is more than Target.

I am getting this kind of Chart below and unable to fullfill the requirement.

Please help me out on this,

Regards,

Pradeep

Re: Change in Target Color based on Budget in Line Chart

Durgadevikumar — Mon, 15 Jun 2020 06:19:34 GMT

Hi,

Good Day😊

Do not change the background color of the budget. Change color only for the target expression,

Provide the below code in background color expression tab of the target expression

= if(Budget<Target, Green(), Red())

And the color is changed as per your requirement.

Regards,

DurgadeviKumar

Re: Change in Target Color based on Budget in Line Chart

pradeep92 — Mon, 15 Jun 2020 06:30:20 GMT

Hi,

Thank you for your response.

We are unable to find that option in Qliksense to change only the specific measure based on expression

= if(Budget<Target, Green(), Red()).

Please provide us the screenshot on the same.

Thanks,

Pradeep

Re: Change in Target Color based on Budget in Line Chart

Kushal_Chawda — Mon, 15 Jun 2020 11:32:49 GMT

You can find it in appearance

Re: Change in Target Color based on Budget in Line Chart

pradeep92 — Mon, 15 Jun 2020 11:40:23 GMT

Hi Bro,

Thank you for the response.

I tried using the same, but the changes are happening for both the measures. I need the Budget in Blue and Target based on Calculation.

Regards,

Pradeep

Re: Change in Target Color based on Budget in Line Chart

Kushal_Chawda — Mon, 15 Jun 2020 14:35:29 GMT

may be below will help as there is no direct way to change the color.

https://community.qlik.com/t5/Qlik-Sense-App-Development/Qlik-Sense-Changing-color-in-combo-chart-line-while-keeping-bar/td-p/1216751

https://community.qlik.com/t5/New-to-Qlik-Sense/Color-by-Expression-Problem/m-p/1140597#1074046

Re: Change in Target Color based on Budget in Line Chart

SerhanKaraer — Tue, 16 Jun 2020 08:43:04 GMT

Hi Pradeep,

If possible, you should define Budget and Target as dimensions in the script.

Then you can specify Budget as blue and Target as calculated color in the "colors and legend" expression.

The idea is to be able to filter the records while colorizing the line.