Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

lowest and highest value In Table with aggr

hello dears

i want find high and low value

i write

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

or

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

108.png

1 Solution

Accepted Solutions
Alvaro_Palacios
Support
Support

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.

View solution in original post

6 Replies
swuehl
MVP
MVP

Are you looking for

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

?

What is your expected outcome?

Not applicable
Author

i expect Show a table with 2 record

FIrst Record is low    (with value)

Second Record is high    (with value)

Kushal_Chawda

see the attached

Not applicable
Author

Thanks But i have only 2 Record Min And Max

Plz Help Me

Min Category

Max Category

Alvaro_Palacios
Support
Support

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

Please see the attached