Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Aggr function to find Min Max values not working

Hi,

I'm trying to put a table chart for each product id, similar statistics box.

Attached sample data that is similar to my scenario, not successful in finding Min and Max values. Somecases, Max value is worked but not Min value as it considers null or zero values.
Appreciate your help.


Regards,

Laks

1 Solution

Accepted Solutions
MVP
MVP

Re: Aggr function to find Min Max values not working

Maybe like attached?

Price is value/qty , right?

I just used min(value/qty) resp. max(value/qty) as expressions.

Hope this helps,

Stefan

1 Reply
MVP
MVP

Re: Aggr function to find Min Max values not working

Maybe like attached?

Price is value/qty , right?

I just used min(value/qty) resp. max(value/qty) as expressions.

Hope this helps,

Stefan

Community Browser