Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ssriramin19
New Contributor II

back ground color

Hello all,

I have requirement based on the values of if condition the back ground color needs to be applied. The given expression is

=IF(IF([ABC Indicator]='A',IF(COUNT([Batch ID])>=20,1,1-fabs((20-COUNT([Batch ID]))/20)),IF([ABC Indicator]='C',IF(COUNT([Batch ID])<=12,1,1-fabs((12-COUNT([Batch ID]))/12)),

IF([ABC Indicator]='B',IF(COUNT([Batch ID])>24,1-fabs((24-COUNT([Batch ID]))/24),IF(COUNT([Batch ID])<11,1-fabs((11-COUNT([Batch ID]))/11),1))))) >=0.9,'G',IF(

IF([ABC Indicator]='A',IF(COUNT([Batch ID])>=20,1,1-fabs((20-COUNT([Batch ID]))/20)),IF([ABC Indicator]='C',IF(COUNT([Batch ID])<=12,1,1-fabs((12-COUNT([Batch ID]))/12)),

IF([ABC Indicator]='B',IF(COUNT([Batch ID])>24,1-fabs((24-COUNT([Batch ID]))/24),IF(COUNT([Batch ID])<11,1-fabs((11-COUNT([Batch ID]))/11),1)))))<0.75,'R','A'))

So For G -Green

A -Yellow

R - Red

The back ground needs to be applied for the value of R,A and G.

Can anyone please suggest me how to provide the back ground color for the above condition.

1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

Re: back ground color

In the attached file, a simplified example of what I suggest.

9 Replies

Re: back ground color

Would you be able to share a sample?

ahaahaaha
Honored Contributor

Re: back ground color

Hi,

May be like this in the window for the background of the expression in the chart

=IF(IF([ABC Indicator]='A',IF(COUNT([Batch ID])>=20,1,1-fabs((20-COUNT([Batch ID]))/20)),IF([ABC Indicator]='C',IF(COUNT([Batch ID])<=12,1,1-fabs((12-COUNT([Batch ID]))/12)),

IF([ABC Indicator]='B',IF(COUNT([Batch ID])>24,1-fabs((24-COUNT([Batch ID]))/24),IF(COUNT([Batch ID])<11,1-fabs((11-COUNT([Batch ID]))/11),1))))) >=0.9,Green(),IF(

IF([ABC Indicator]='A',IF(COUNT([Batch ID])>=20,1,1-fabs((20-COUNT([Batch ID]))/20)),IF([ABC Indicator]='C',IF(COUNT([Batch ID])<=12,1,1-fabs((12-COUNT([Batch ID]))/12)),

IF([ABC Indicator]='B',IF(COUNT([Batch ID])>24,1-fabs((24-COUNT([Batch ID]))/24),IF(COUNT([Batch ID])<11,1-fabs((11-COUNT([Batch ID]))/11),1)))))<0.75,Red(),Yellow()))

ssriramin19
New Contributor II

Re: back ground color

Below highlighted column in table needs to given back ground color for various values of R,G and A

data_2.jpg

ssriramin19
New Contributor II

Re: back ground color

the entire column is becoming green color and not the values are shown in this case, I want to be like

data_2.jpg

Re: back ground color

ssriramin19
New Contributor II

Re: back ground color

It would be better if you can tell how to rewrite the expression for color combination

Thanks

Sriram

Re: back ground color

Is this for me? I am not sure how to write anything before I see more then just an expression...

ahaahaaha
Honored Contributor

Re: back ground color

In the attached file, a simplified example of what I suggest.

ssriramin19
New Contributor II

Re: back ground color

Thanks very much for your help,It was good to proceed with

Community Browser