topic Re: Max Value in QlikView

Max Value

Fri, 07 Nov 2014 11:03:16 GMT

Hi all,

I wanted to find a way to calculate the maximum sales value by Category Name i.e. Baby Clothes, Men's clothes. The idea is to see which category sells the most. How can I achieve this?

Re: Max Value

MK_QSL — Fri, 07 Nov 2014 11:06:16 GMT

Max(TOTAL <CategoryName> Aggr(SUM(LineSalesAmount),CategoryName))

Re: Max Value

Fri, 07 Nov 2014 11:17:08 GMT

Thanks.

Assuming I have the following scenario:

Column 1 and Column 2 are expressions. I wanted to show only the max value for Column 1 and max value for Column 2

Re: Max Value

Fri, 07 Nov 2014 11:18:47 GMT

try

firstsortedvalue(empname,-coloumn1) for max value

Re: Max Value

jyothish8807 — Fri, 07 Nov 2014 11:21:00 GMT

Hi Sabah,

What do you mean by max value for Column 1 and 2?

Column1=-58007

Column2=-30264

Am i right?

Regards

Re: Max Value

Fri, 07 Nov 2014 11:24:24 GMT

By max, I mean the max negative number. I.e Column 1 max value is -443009 and max value is -119994

Re: Max Value

Fri, 07 Nov 2014 11:29:04 GMT

firstsortedvalue(empname,coloumn1) for max value

firstsortedvalue(empname,coloumn2) for max value

write 2 separate expressions like above u will get