Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: lowest and highest value In Table with aggr

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.

6 Replies
MVP
MVP

Re: lowest and highest value incorrect

Are you looking for

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

?

What is your expected outcome?

Not applicable

Re: lowest and highest value incorrect

i expect Show a table with 2 record

FIrst Record is low    (with value)

Second Record is high    (with value)

Re: lowest and highest value incorrect

see the attached

Not applicable

Re: lowest and highest value In Table with aggr

Thanks But i have only 2 Record Min And Max

Plz Help Me

Min Category

Max Category

Employee
Employee

Re: lowest and highest value In Table with aggr

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.

Re: lowest and highest value In Table with aggr

Please see the attached

Community Browser