topic how to evaluate the max value in QlikView

how to evaluate the max value

Wed, 18 Dec 2013 10:38:32 GMT

Hi All,

i have a table which contains 2 columns (Product, Sales)

i want to make a straight table which show each product and its Sales(clear till now) and a third column shows the sales of the product divided by the max value of sales even it's + or -

Product	Sales
x	1000
y	-3000
z	2500

as cleared above the max value of sales is 3000 so i want the third column to be

Product	New Value
x	1000/3000
y	-3000/3000
z	2500/3000

but note that i'm writing set expression to get the sales it's not static value

how to make the new value??

Re: how to evaluate the max value

Wed, 18 Dec 2013 10:42:13 GMT

Hi Mona

an easy way is to store in a variable max(Sales) (gives max from selected records)

and use it to divide in your expression as Sum(Sales)/$(var)

best regards

Chris

Re: how to evaluate the max value

luciancotea — Wed, 18 Dec 2013 10:45:44 GMT

=SUM( Sales ) / MAX( TOTAL fabs( aggr( SUM( Sales ), Product )))

Re: how to evaluate the max value

Wed, 18 Dec 2013 10:46:04 GMT

it's not working

Re: how to evaluate the max value

tresB — Wed, 18 Dec 2013 10:52:27 GMT

Try :

=Sum(Sales)/ Max( total fabs(Sales))

PFA