topic How to flag out history records using load script Or expression ?? in QlikView

How to flag out history records using load script Or expression ??

Wed, 16 Jun 2010 12:26:32 GMT

Hi All ,

I need to perform a bit of history management with my member profile .

Here i am attaching data file . "Input" sheet contains data which i am recieving , while after loading script i need to store what mentioned in "Output" sheet into QVD file.

Can anybody advice me with load script ?

One more question can this be also taken care in chart - expression itself ,if Yes, then how ???

Looking for urgent help .

Regards,

Bhushan N

How to flag out history records using load script Or expression ??

Wed, 16 Jun 2010 21:34:40 GMT

based on what condition are you determining the status field? I don't see anything in the import file that gives any indication if something is updated.

Can you be more specific about your requirement? What are you actually trying to acomplish?

How to flag out history records using load script Or expression ??

Thu, 17 Jun 2010 06:22:54 GMT

Hi ,

Here i mainly want to focus on to maintain history in customer DB.

There are different business logic which works to determine level of a particular customer . So here i need to consider

1) Latest record of the customer which nothing but latest customer records datewise.

2) If customer exists in DB , then make previous record as "Modified" & make latest record as "Active".

Rgeards,

Bhushan N