How to get three oldest man 's name here in straight table or barchart?

[ananyaghosh]

Hi,

I have tables below.

How to get three oldest man 's name here in straight table or bar chart?

PeopleTemp:

LOAD * INLINE [

    PersonID, Person

    1, Jane

    2, Joe

    3, Shawn

    4, Sue

    5, Frank

    6, Mike

    7, Gloria

    8, Mary

    9, Steven,

    10, Bill

];

//Add dummy age data

AgeTemp:

LOAD * INLINE [

    PersonID, Age

    1, 23

    2, 45

    3, 43

    4, 30

    5, 40

    6, 32

    7, 45

    8, 54

    9,

    10, 61

    11, 21

    12, 39

];

[Peter_Cammaert]

Use a dimension limit "Show First 3". Sort by expression (if age is not part of your table): age, descending.

But how to we separate men & women?

Peter

[#3]

Please find solution in attached QVW file.

[MarcoWedel · Accepted solution]

Hi,

another solution might be:

hope this helps

regards

Marco