topic Re: Displaying numbers in QlikView

Displaying numbers

Thu, 28 Aug 2014 05:37:49 GMT

lets say i have a field of number. eg total working hours in a week. so this may contain numbers like 30,43,34 and so on.

I want to display the largest and the smallest number and ofcourse it should get updated as the file gets updated.

kindly let me know the solution(s)

thanks in advance

avinashelite — Thu, 28 Aug 2014 05:39:26 GMT

use MAX() and MIN() function.

Thu, 28 Aug 2014 05:46:19 GMT

Hi,

For largest value

Max(filed)

For lowest value

Min(field)

Thu, 28 Aug 2014 06:27:43 GMT

could you please explain how to use it.

little details abt it

Thu, 28 Aug 2014 06:38:44 GMT

Hi,

you can use it in text object or in charts expression

for ex:

in text object : =Max(totalworkinghours)

for min: Min(totalworkinghours)

In Charts:

Max(sum(totalworkinghours))

and Min(sum(sum(totalworkinghours))

Thu, 28 Aug 2014 06:42:46 GMT

I was missing '='

now it works.

thanks