Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Keep last record per date, per person

Hello, I am having a little trouble filtering my data.. I have titles for employees by month. If someone's title changes in a certain month, I want only one of the records ( I don't care if it's the first or the second). I can't seem to figure out how to do this. Below is a screenshot of what I am referring to.

Thank you!

Qlik Question.PNG

Tags (2)
1 Solution

Accepted Solutions

Re: Keep last record per date, per person

May be like this:

LOAD Accounting_End_Date,

          Timekeeper_Initials,

          MaxString(Hist_Title) as Hist_Title

FROM....

Group By Accounting_End_Date, Timekeeper_Initials;

6 Replies

Re: Keep last record per date, per person

Are you looking for this in the script?

Not applicable

Re: Keep last record per date, per person

Yes.

Re: Keep last record per date, per person

May be like this:

LOAD Accounting_End_Date,

          Timekeeper_Initials,

          MaxString(Hist_Title) as Hist_Title

FROM....

Group By Accounting_End_Date, Timekeeper_Initials;

MVP & Luminary
MVP & Luminary

Re: Keep last record per date, per person

Try the FirstValue or LastValue function:

LOAD

     Accounting_End_Date,

     Timekeeper_initials,

     FirstValue(Hist_Title) as Hist_Title

FROM

     ...

GROUP BY

     Accounting_End_Date,

     Timekeeper_initials

     ;


talk is cheap, supply exceeds demand
Not applicable

Re: Keep last record per date, per person

That worked! Thank you!

Not applicable

Re: Keep last record per date, per person

This also worked. Thank you very much!

Community Browser