topic conditional formatting in QlikView

conditional formatting

CB308 — Thu, 15 Oct 2009 20:45:31 GMT

I want to use conditional formatting (color of fond and background) which would make it easier for users to identify the following in their table.

The value of the expression is as follows: =num(sum (Sales)/sum(Total <Style>(Sales)))

I would like to identify which styles equal the top 50% of total sales by highlight the cell(s) in green and additionally the styles that equal the to 85% in yellow.

Style A and B % Ttl column should be green while style C should be yellow.

Current
Style	Sales Ranking	% Ttl	Cuml %	Ranking
A	100	37.04%	37.04%	1
B	50	18.52%	55.56%	3
C	60	22.22%	77.78%	2
D	40	14.81%	92.59%	4
E	20	7.41%	100.00%	5
Total	270	100.00%

Desired
Style	Sales Ranking	% Ttl	Cuml %	Ranking
A	100	(green)37.04%	37.04%	1
B	50	(green)18.52%	55.56%	3
C	60	(yellow)22.22%	77.78%	2
D	40	14.81%	92.59%	4
E	20	7.41%	100.00%	5
Total	270	100.00%

conditional formatting

Thu, 15 Oct 2009 21:15:03 GMT

Expand the Expression node and go into text colour.

Then add the expressions and corresponding value

IF(num(sum (Sales)/sum(Total <Style>(Sales)))>=0.85,Rgb(xx,xx,xx), IF(=num(sum (Sales)/sum(Total <Style>(Sales)))>=0.5,Rgb(0,255,255)))

Hope this is what you want...

conditional formatting

CB308 — Thu, 15 Oct 2009 21:32:10 GMT

thanks so much for your quick response....

I'm getting error in expression... am i missing something?

IF(num(sum (Sales)/sum(Total <Style>(Sales)))>=0.85,Rgb(xx,xx,xx), IF(=num(sum (Sales)/sum(Total <Style>(Sales)))>=0.5,Rgb(0,255,255)))

will this provide a color for when >50% and a color for when > 85%?

conditional formatting

Oleg_Troyansky — Fri, 16 Oct 2009 21:53:04 GMT

you have an unnecessary equal sign "=" after the second IF. I believe the rest should be OK