Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

aggr

Hi everybody

I've a little aggr issue to solve

Some people have 2 status. When there are different i can't display the last one.

Ex :

Name     Date          Status

A             2/11/13       open

A             2/12/13      stand by

B            5/11/13        open

B           2/12/13         open

What i get is

Name     Status

A             -

B          open

and I'd like to get Status Stand by for A

I tried to aggregate on max(date) but it didn't work

Thank you for your help

Chris

Tags (1)
1 Solution

Accepted Solutions

Re: aggr

USE STRAIGHT TABLE

Dimension = Name

Expression = FIRSTSORTEDVALUE(Status, -Date)

5 Replies

Re: aggr

USE STRAIGHT TABLE

Dimension = Name

Expression = FIRSTSORTEDVALUE(Status, -Date)

Not applicable

Re: aggr

Christian,

Did you try FirstSortedValue ?

FirstSortedValue(Status, -Date)

Fabrice

MVP
MVP

Re: aggr

PFA

Not applicable

Re: aggr

Hi Guys

you're all right.

I was just deep inside aggr function. I will therefore remember this one

thank you,

Chris

Not applicable

Re: aggr

Wellcome Christian,

I think you can also use it with the LOAD statement (and GROUP BY)

Fabrice

Community Browser