topic Re: Get max value in QlikView

Get max value

Tue, 10 Dec 2013 14:27:50 GMT

Hello, i think my issue is not so difficult to solve but i can't tackle it.

Indeed, i have a simple array with 2 rows: WEEK and VALUE

I want to get the value of the highest WEEK:

for exemple : WEEK | VALUE

23 1

24 4

25 2

I have a textbox and i would like to return: 2.

How can i do that?

Thank you in advance

MayilVahanan — Tue, 10 Dec 2013 14:31:49 GMT

Try like this

=Sum({<Week = {$(=Max(Week))}>}Value)

Tue, 10 Dec 2013 14:45:51 GMT

Thank you! You are perfect

Tue, 10 Dec 2013 15:10:32 GMT

I know your got this answered - but you could also do like this:

I make a ApplyMap (Lookup) where i find the matching value from the latest week by peeking into the column.

Tue, 10 Dec 2013 17:05:46 GMT

Dear friend, i have now another problem,

ID | WEEK | VALUE

1 23 1

1 24 4

1 25 2

2 23...

2 25..

2.....

I would like to Sum value between max week for each ID. Is it possible ?

I did

=Sum(TOTAL aggr({<week= {$(=Max(week))}>}value,id))

but doesn't work.

Thank you