topic Re: How to get updated Records in QlikView

How to get updated Records

dhananjay_capge — Mon, 01 Jun 2015 06:20:08 GMT

Hi there,

i have sample data like

ID,
Name,
Dat

Currently data shows 3 records with 2 same ID.

But i want to show updated data as per date update.
Output should be below screen-shot.

Thanks,

Re: How to get updated Records

tresB — Mon, 01 Jun 2015 06:27:02 GMT

You mean, if duplicate Ids are there, it should take the one with latest date? If so, you can do it in the front-end easily like:

Straight table:

Dim1:Id

Dim2: Name

Exp: Max(Dat)

In the script like:

Load

Id,

Name,

Max(Dat) as Dat

From <> group by Id, Name;

Re: How to get updated Records

Mon, 01 Jun 2015 06:33:54 GMT

Hi,

As see Name is different and ID is only same

Load

Id,

Name,

Dat

From Table1 ;

Load

Id,

Max(Dat) as Dat

From <> group by Id;

Now Join Table A and B based on Column ID and Dat and fetch all columns from table A.

Re: How to get updated Records

dhananjay_capge — Mon, 01 Jun 2015 06:36:38 GMT

Hi Tresesco,

Yes, Your understanding is right.

But when i excute this logic it will show all data.kindly check.

Still it shows the all records.

Thanks,

Re: How to get updated Records

jonathandienst — Mon, 01 Jun 2015 06:37:34 GMT

I assume you want the name for the maximum date as well as the date itself for the ID. Use a straight table:

Dimension: id

Expr1: FirstSortedValue(Name, -Dat)

Expr2: Max(Dat)

Re: How to get updated Records

jonathandienst — Mon, 01 Jun 2015 06:39:40 GMT

To do this in the load script:

LOAD id,

FirstSortedValue(Name, -Dat) As Name,

Max(Dat) As Dat

FROM ...

GROUP BY id;

Re: How to get updated Records

tresB — Mon, 01 Jun 2015 06:42:30 GMT

I should have noticed the Name thing earlier. In that case, follow Jonathan's second suggestion below.

Re: How to get updated Records

prajapatiamar38 — Mon, 01 Jun 2015 07:23:26 GMT

Hi.....

Please find the attachment below.

As said by Jonathan dienst it is correct.

Thanks