topic Re: max value for each product ? in QlikView

max value for each product ?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

i have 100 records in sales field

and to al distinct products are 10 having like

product1,product2,product3....product10

i want get the max value for each product in front end text object.. ?

how to do it this calculation only in front end

Chanty4u — Wed, 16 Mar 2016 06:51:11 GMT

u can create a max(Product1...10)

in script

Kushal_Chawda — Wed, 16 Mar 2016 06:53:57 GMT

put the below expression text object. You can select the products from list box

=Product & ' '& max(Value)

avinashelite — Wed, 16 Mar 2016 07:06:10 GMT

did not get the exact requirement ... share the sample data and the output that your excepting

try like this

agg(max(value),Product)

amayuresh — Wed, 16 Mar 2016 07:13:23 GMT

try this,

I have like

LOAD * INLINE [

Product, Value

A, 10

B, 20

C, 30

D, 40

A, 5

B, 20

D, 50

C, 40

A, 50

B, 100

D, 60

];

Text object expression = concat(if(aggr(Max(Value),Product),Product&' = '&aggr(Max(Value),Product)&CHR(13)))

Get result like

Digvijay_Singh — Wed, 16 Mar 2016 07:36:17 GMT

Bit simpler

=Concat(Aggr(Product & '= ' & Max(Value),Product),Chr(13))