topic Re: Max and Min values in QlikView

Max and Min values

Mon, 10 Oct 2011 06:39:27 GMT

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.

Max and Min values

kaushiknsolanki — Mon, 10 Oct 2011 06:43:42 GMT

Hi,

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

Regards,

Kaushik Solanki

Re: Max and Min values

SunilChauhan — Mon, 10 Oct 2011 07:01:05 GMT

see the attched file

hope this helps

Re: Max and Min values

Mon, 10 Oct 2011 07:14:56 GMT

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

Re: Max and Min values

its_anandrjs — Mon, 10 Oct 2011 07:16:43 GMT

Hi,

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

Rgds

Anand

Max and Min values

SunilChauhan — Mon, 10 Oct 2011 07:18:28 GMT

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

Re: Max and Min values

Mon, 10 Oct 2011 07:30:44 GMT

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

Max and Min values

SunilChauhan — Mon, 10 Oct 2011 07:45:00 GMT

after reloading attach the sample

Max and Min values

Mon, 10 Oct 2011 07:56:01 GMT

Sorry I dont understand what you mean.

Max and Min values

SunilChauhan — Mon, 10 Oct 2011 07:57:38 GMT

reload the test.qvw and then attach here

or else provide xls files

Re: Max and Min values

Mon, 10 Oct 2011 08:01:58 GMT

Here it is