Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

visual indication

Hello everybode

I have a excell sheet with som number, a total and an average

http://img338.imageshack.us/img338/1038/qlikexcell.jpg

in Qlikview i made ta table of them and want qlikview to highlight the numbers (color green and bold) if the value is above average, and red and bold if belowe average.

when i select only one row i got it working numbers above avg are green and below are red (hard to see)

http://imageshack.us/a/img23/598/qlikviewgoed.jpg

but when a select more then one value it goes wrong. al numbers turn red. What am I doing wrong???

http://imageshack.us/a/img254/8937/qlikviewfout.jpg

I put the expression for the average between (   ) in the box for visual indication Top and Bottom.

http://img843.imageshack.us/img843/4285/qlikviewexpress.jpg

anybody ????

Help would be very welcome

regards Ed

1 Solution

Accepted Solutions

Re: visual indication

Go to the Expression tab and click on the + in front of the expression A and click on Text Color. In the textbox for Definition put this expression:

if(sum(A)>=(sum(A)+sum(B)+sum(C))/3,green(),if(sum(A)<(sum(A)+sum(B)+sum(C))/3,red()))

Do the same for the other two expressions, if(sum(B)>= ...etc and if(sum(C)>= ...etc


talk is cheap, supply exceeds demand
5 Replies
Not applicable

Re: visual indication

send sample file or write here list of dimension and expressions in your chart

Not applicable

Re: visual indication

dimensions are the days of the week (monday-sunday)

and I have for each day 3 koloms with numbers (A, B and C)

in the chart the dimension is weekday, expressions A,B,C,Total,Average

weekday     A     B     C     totalABC    averageABC

monday,               

tuesday

expression in the chart I use; sum , sum , sum , (Sum ()+Sum ()+Sum ()) and (sum ()+sum ()+sum())/3

for the visual indication i use the formula ((sum ()+sum ()+sum())/3)

if i select only monday it works fine

if i select monday and tuesday it won't work

i use the personal edition so i cant open file's from other user

grtz Ed

Re: visual indication

Go to the Expression tab and click on the + in front of the expression A and click on Text Color. In the textbox for Definition put this expression:

if(sum(A)>=(sum(A)+sum(B)+sum(C))/3,green(),if(sum(A)<(sum(A)+sum(B)+sum(C))/3,red()))

Do the same for the other two expressions, if(sum(B)>= ...etc and if(sum(C)>= ...etc


talk is cheap, supply exceeds demand
Not applicable

Re: visual indication

hey Thanx

did.not think of that option

bedankt

groeten Edwin

Not applicable

Re: visual indication

the condition

( ((sum ()+sum ()+sum())/3))

is calculated outside the dimension so it gives result like 13,3333

you can use it only when you want to mark all the rows above/below the same value

Community Browser