topic Re: Another max row question in QlikView

Another max row question

Tue, 24 Jul 2012 13:51:12 GMT

I have been looking through the form to solve my max row problem, I think I'm close, but still not getting it! This is what I'm trying to do

I have campus 1, and 2 (column called campus)

I have Units ICC,OR,ER .. many more (each unit may or may not be on both Campuses)

Each Unit has many rows with a update, and a archive_id for a single day.

I can get the max archive_id by using the function =aggr(max(ArchiveSnapshot_ID),campus,Unit_Name) as a Dimension.

What I'm not getting is a expression (I think) that will display the max row, per campus , unit based on the selection. If no selection is made when opening the doc I would like to see all max rows for each campus/ units. Again each campus may or may not have a the same unit.

Example

Campus, Unit, Update, Archive_id

-----------------------------------------

campus 1, ER ,7/29/2012,12

campus 1 , ER, 7/20/2012. 23

campus 1, OR, 7/20/2012 9

campus 2, ER ,7/20/2012, 15

campus 2, ICC,7/20/2012. 34

campus 2, ICC,7/20/2012 36

Display should look something like this:(default) unless 1 or more units are selected, then only those units will be displayed

campus 1 , ER, 7/20/2012. 23

campus 1, OR, 7/20/2012 9

campus 2, ER ,7/20/2012, 15

campus 2, ICC,7/20/2012 36

Re: Another max row question

Tue, 24 Jul 2012 16:08:19 GMT

you mean something like this?

Re: Another max row question

Tue, 24 Jul 2012 16:11:40 GMT

Yes, and no. I still need both er's from both campuses.

Re: Another max row question

Tue, 24 Jul 2012 16:28:35 GMT

I figured it out... I was using =aggr(max(Archive_id), Campus,Unit) and the answer is =aggr(max(Archive_id), Unit,Campus). I'm not sure why, maybe someone could expain the order thing to me..

Re: Another max row question

Tue, 24 Jul 2012 16:41:14 GMT

Well ok it solved part of the problem, but it looks like it is assigning the max row to the wrong row. I added a comment column to the qvw you posted. One can see that Campus1 and ER unit should say " Bye" and not the word "Hi" in the comments column.

See new updated file.