topic Re: find maximum amount order in QlikView

find maximum amount order

vipin_mishra479 — Fri, 10 May 2013 10:48:10 GMT

Hi All,

Here i have atteched my example file

where i get max amount with respect of product desc

but how can i find max amount of product order in this table.

eg:-

SB47 BLADE 23.32

SB47 BLADE SERVICE KIT 0.11

i want

SB47 BLADE 6395003789 23.32

SB47 BLADE SERVICE KIT 4395093412 0.11

Re: find maximum amount order

er_mohit — Fri, 10 May 2013 11:02:48 GMT

try Firstsorted value concept

see this example

Test:

LOAD month(Date)as MONTH,* INLINE [

Order no, Date, Value

a, 01-02-2013, 1

f, 02-02-2013, 2

w, 03-02-2013, 3

a, 04-03-2013, 4

e, 05-03-2013, 5

f, 07-03-2013, 6

a, 07-04-2013, 7

f, 07-04-2013, 8

g, 07-04-2013, 9

g, 07-05-2013, 10

f, 07-05-2013, 11

];

LOAD [Order no],

MAX(date(DATE#(MONTH,'MMM'),'MMM')) as Max_Mo,

FirstSortedValue(Value,- date(DATE#(MONTH,'MMM'),'MMM')) as Latestvaluemax

Resident Test

Group By [Order no];

Re: find maximum amount order

kumarnatarajan — Fri, 10 May 2013 11:05:19 GMT

Hi,

find the attached file.

Re: find maximum amount order

Gysbert_Wassenaar — Fri, 10 May 2013 11:07:29 GMT

See attached example.

Re: find maximum amount order

vipin_mishra479 — Tue, 14 May 2013 04:08:23 GMT

Hi gysbert ,

your expression is fine for suitable example but when i try in my expression is not work

my expression is that

i have find max amount for using this expression

max(aggr(sum({<model = {'SB42'},country = {'India'}>}Amount),Product_Desc,Product_Order)

So will u please tell me how to find max Amount Order

and i have tryed firstShorted value but there have some problem

when amounts are same then it show blank

So will u please suggest what i do