Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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

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

];

Tags (1)
1 Solution

Accepted Solutions
Highlighted

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

Hi,

another solution might be:

QlikCommunity_Thread_164289_Pic1.JPG

QlikCommunity_Thread_164289_Pic2.JPG

hope this helps

regards

Marco

View solution in original post

3 Replies
Highlighted

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

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

Highlighted
Not applicable

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

Please find solution in attached QVW file.

Highlighted

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

Hi,

another solution might be:

QlikCommunity_Thread_164289_Pic1.JPG

QlikCommunity_Thread_164289_Pic2.JPG

hope this helps

regards

Marco

View solution in original post