topic Simple Question about max() function in QlikView

Simple Question about max() function

Mon, 11 Apr 2011 09:59:54 GMT

Hi Everybody,

I want to change the color in bar chart as the following :

Red for the higher value and Green for the lower value

So, under bar chart properties >> Expressions >> "+" >> Background Color >> Definition I(ve written this :

if(data%Table-above(data%Table)=max(data%Table-above(data%Table)),LightRed()) but It doesn't work

However, if I write this :

if(data%Table-above(data%Table)=23,LightRed()) it works

Do you know what is wrong with max function ?

Thank you

Simple Question about max() function

sushil353 — Mon, 11 Apr 2011 10:03:15 GMT

Dear jeremy02,

first calculate the max function and store the value in a variable and then apply your expression.

I hope that might work.

TC 🙂

Simple Question about max() function

Mon, 11 Apr 2011 10:34:50 GMT

Hi Sushi,

First, thank you to help me.

As you told me I have to do the following :

max_value = max(data%Table-above(data%Table))

if data%Table-above(data%Table)= max_value, lighred()

My question is to know where to do the first line ? Because I think that we can just add 1 expression at the same time no ?

Simple Question about max() function

Mon, 11 Apr 2011 10:58:56 GMT

ok the problem is that the expression "data%table - above(data%table)" return nothing

How can I get a field with this : NewField = Field(i) - Filed(i-1)

Thank you

Simple Question about max() function

Tue, 12 Apr 2011 10:23:10 GMT

Good Morning Everybody,

I've a field with counter number (for example Index) :

Index

123
160
176
180
250

If I do : "Variable = Max(Index)" I get 250 this is ok but if I do "Above(Index)" I get :

Above(Index)

-
123
160
176
180
250

and Max(Above(Index)) returns this '-'

The aim is to make a difference between Index and Above(Index)

Thank you

Simple Question about max() function

matt_crowther — Tue, 12 Apr 2011 10:53:26 GMT

In teh expression of the Background colour setting of your expression use the 'rank()' function to determine the top and bottom values and assign the colours required in much the same way as your initial example.

This method works for me and you don't need to get bogged down in variables.

Something along the lines of (unchecked):

=if(rank(Sum(Sales))=1,rgb(198,255,198),if(ranksum(Sales),4)=1,rgb(255,198,198),rgb(255,255,255)))

If you get stuck have a look in the help file.

Hope that helps,

Matt - Visual Analytics Ltd

Simple Question about max() function

Tue, 12 Apr 2011 13:03:49 GMT

I've a question Matt :

This is the Field named "Index" and the return values of the expression rank(Index)

Is it normal that I get exactly the same ranking if I write rank(Index,0) or rank(Index,1) or rank(Index,2) ... ? According to the help no, do you knwo the reason ?

Thank you