Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Loading the most up to date Account history

Hello,

I'm hoping this will be a relatively simple query. I have a large amount of data and I only want to load the most up to date information. Table 1 belows shows an example of what I currently have, and basically I only want the latest DateChange data to come across, which is shown in Table 2. It seems to be an easy concept however I can't think of what to do in the script.

Thanks

Table 1

AccountNoDateChangeTariff
AB12345605/02/06HE
AB12345604/08/10E7
CD12345602/01/03HE
CD12345605/04/07E7
CD12345608/09/09HE
EF12345602/03/07HE
GH12345602/05/08E7

Table 2

AccountNoDateChangeTariff
AB12345604/08/10E7
CD12345608/09/09HE
EF12345602/03/07HE
GH12345602/05/08E7
Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Loading the most up to date Account history

Check out this attached application.

- Sridhar

2 Replies
Not applicable

Re: Loading the most up to date Account history

Check out this attached application.

- Sridhar

Not applicable

Re: Loading the most up to date Account history

That's great sridhar24784, many thanks for this.

Community Browser