topic Re: Color Issue in QlikView

Color Issue

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

I have some KPI's that have some range for background color. I m not able to achieve it.

For each KPI i have different range for color, that too in feature also it may change or may not change.

How to automate those background color can any one suggest me .

Pleasse find attached app for ref.

Re: Color Issue

subbareddykm — Tue, 28 Mar 2017 08:40:27 GMT

is there any chance to get this?

Re: Color Issue

ahaahaaha — Tue, 28 Mar 2017 09:12:52 GMT

Hi,

An example is given in the attached file.

The color code fragment (for the first two KPI)

If([KPI Name]= 'KPI 1' And Value>=90, Green(),

If([KPI Name]= 'KPI 1' And (Value>=70 And Value<90), Yellow(),

If([KPI Name]= 'KPI 1' And Value<70, RGB(250,100,100),

If([KPI Name]= 'KPI 3' And Value>=86, Green(),

If([KPI Name]= 'KPI 3' And (Value>=84.3 And Value<86), Yellow(),

If([KPI Name]= 'KPI 3' And Value<84.3, RGB(250,100,100),

...

))))))

Regards,

Andrey

Re: Color Issue

subbareddykm — Tue, 28 Mar 2017 09:22:08 GMT

This is not as i want , i already mentioned there my range is not fixed.

I need to automate this.

I have one solution but don't know to how do this,

Can i create start range for every KPI for Each color.

Example : KPI 1 Green range is 90 to 100,yellow 70 to 90 and red 0 to 69

I hope u understand it.

Re: Color Issue

ahaahaaha — Tue, 28 Mar 2017 09:28:35 GMT

You change the value of Value and reload the data. Does not the color change?

Re: Color Issue

avinashelite — Tue, 28 Mar 2017 09:42:11 GMT

Create variables for each range like

vGreen

=90

vYellow

=70

vRED

Then if(values>vGreen,green(),

if(values>vYellow,yellow(),

f(values>vRED,RED(),

)))

Re: Color Issue

subbareddykm — Tue, 28 Mar 2017 09:48:37 GMT

Range is not fixed for each kpi is may change,

if u see the range for each KPI, it is different .

As per Ur suggestion if i store value in it, after few day , i may change.

Re: Color Issue

subbareddykm — Tue, 28 Mar 2017 09:54:41 GMT

Your suggestion will work,if value chages and range is fixed,

But in my case range will change and value will also will change.

Re: Color Issue

jonathandienst — Tue, 28 Mar 2017 10:06:38 GMT

Andrey is on the right track. Set the background color expression for Value:

If([KPI Name] = 'KPI 1',

If(Value > 90, Green(90),

If(Value > 70, Yellow(), Red(90))),

If([KPI Name] = 'KPI 3',

If(Value >= 86, Green(90),

If(Value > 84.3, Yellow(), Red(90)))

// and so on for the remaining KPIs

))

I have done the first two for you. Use the same logic and add the remaining conditions. For the expression above, you will get:

PS - I added opacity to Green and Red so the numbers are visible. You could use LightRed() and LightGreen() instead.

Re: Color Issue

subbareddykm — Tue, 28 Mar 2017 10:26:08 GMT

Hi,

Jonathan,

Its not working,

Lets take one example,If my KPI 1 is in future like below

>=60% green 40-69% yellow <40% red

If i use like above expression ,will not work right.

Re: Color Issue

ahaahaaha — Tue, 28 Mar 2017 11:18:53 GMT

As variant, you can then add fields in which to load dynamically the range limits (in the latter case, 40 and 60? I hope 69 is an error). These fields can be used in color expressions similarly to field [KPI Name]. Later you can no to show the fields of the ranges borders on the diagram.

Regards,

Andrey

Re: Color Issue

subbareddykm — Tue, 28 Mar 2017 12:41:05 GMT

Sorry its not 69 its 59.

Like that scenario ,that logic will not work right.

So please suggest some solution on that