topic Re: Min and Max value? in QlikView

Min and Max value?

dmohanty — Wed, 14 May 2014 08:54:16 GMT

Hi All,

I have an Inline table of data like this below:

Tab:

Load * inline
[

Country, Year, Sales
A,2013,5
A,2014,5
B,2013,10
B,2014,10
C,2013,3
C,2014,2
D,2013,8
D,2014,7

];

I am showing a Straight Table to display Country and Sum(Sales)

A10 B20 C5 D15

Now requirement is : In a Text Object, I have to show Min (Sales) and Max (Sales)

Min(Sales) = 5 for Country C

Max(Sales) = 10 for Country B

Also, if Year is Selected, the Min and Max value have to change accordinly as per Inline Data.

Please help to display the Min and Max value

Regards!

Re: Min and Max value?

CELAMBARASAN — Wed, 14 May 2014 09:08:41 GMT

Did you checked

=Min(Sales)

and

=Max(Sales)

in Text object?

Any difficulties with that or I misunderstood?..

Re: Min and Max value?

Anonymous — Wed, 14 May 2014 09:09:38 GMT

PFA

Solution for the requirement.....

Regards

Nitin

Re: Min and Max value?

dmohanty — Wed, 14 May 2014 09:14:53 GMT

Great!! Thanks Nitin.

Exactly this is what I wanted. Aggr() helped.

Re: Min and Max value?

dmohanty — Wed, 14 May 2014 09:16:32 GMT

Hi Celambarasan,

NO, That won't help. I guess you missed a little.

Min(Sales) will give 2

Max(Sales) will give 10 which are not desired.

I had wanted like this :

Min(Sales) = 5 for Country C

Max(Sales) = 10 for Country B

Re: Min and Max value?

Anonymous — Wed, 14 May 2014 09:30:42 GMT

Welcome...

Re: Min and Max value?

Wed, 14 May 2014 09:49:54 GMT

just simply put min(sales) and max(sales) in text object.