topic Re: lowest and highest value incorrect in QlikView

lowest and highest value In Table with aggr

Fri, 28 Aug 2015 08:51:57 GMT

hello dears

i want find high and low value

i write

Min(Aggr(Sum(Value),Category))

Max(Aggr(Sum(Value),Category))

But incorrect

I expect a great record and display a small record (Two Record in one Table)

plz help me

swuehl — Fri, 28 Aug 2015 09:16:04 GMT

Are you looking for

=Max(TOTAL<Category> Aggr( Sum(Value), Category, SubCategory))

What is your expected outcome?

Fri, 28 Aug 2015 09:18:10 GMT

i expect Show a table with 2 record

FIrst Record is low (with value)

Second Record is high (with value)

Kushal_Chawda — Fri, 28 Aug 2015 10:55:34 GMT

see the attached

Fri, 28 Aug 2015 11:19:17 GMT

Thanks But i have only 2 Record Min And Max

Plz Help Me

Min Category

Max Category

Alvaro_Palacios — Fri, 28 Aug 2015 11:42:38 GMT

Hi Leila,

The easiest way to achieve that table is using the load script instead. Please find the solution attached.

Hope it helps.

Alvaro P.

Kushal_Chawda — Fri, 28 Aug 2015 12:45:14 GMT

Please see the attached