Max and Min values

[#1]

Hi,

I've just started using QlikView and i'm not so familiar with the sheet objects.

I want to create an object which can show the 3 maxium and 3 minium values from an existing table.

How do I go about doing this?

Thanks.

[kaushiknsolanki]

Hi,

    Can you please describe your problem in detail with example and sample application.

Regards,

Kaushik Solanki

[SunilChauhan]

see the attched file

hope this helps

[#4]

Hi Sunil,

I'm using the personal trial version on my pc and when I open your file it shows me an error message saying allocated memory exceeded.

Regards,

Mandeep

[its_anandrjs]

Hi,

Try to use Max(YourField,3) and Min(YourField,3) to find max and min

Rgds

Anand

[SunilChauhan]

load this into ur application

Load * inline [

Name,sales

a,10

b,20

c,30

d,40

e,50

f,60

g,70

h,80

];

take a bar chart

in dimention taake Name

and in expression

sum({<sales={">=$(=max(sales,3))<=$(=min(sales,3))"}>}sales)

and see ur result

[#7]

Hello

Thanks for this,

The problem that I have is that, I have a table with dimension and 4 categories (A, B, C and D). What I want to do is that from each category I want to show the top 3 and bottom 3 values and the corresponding dimension.

How do I go about doing this? I’ve attached the sample file.

Thanks in advance!

Regards

Mandeep

[SunilChauhan]

after reloading attach the sample

[#9]

Sorry I dont understand what you mean.

[SunilChauhan]

reload the test.qvw and then attach here

or else provide xls files