Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

New data entry details need to be notified

Hi,

I am looking for input on below:

I am having QVD which hold all the historical data. If any new data comes(on Adhoc basis) which need to compare first with QVD. After comparison fresh data details need to be alerted via email and store data into QVD.

Attaching sample file for reference.

Thanks in advance!!

Rohit

6 Replies
Not applicable
Author

Attachment for your reference.

Thanks,

Rohit

Anil_Babu_Samineni

How QVD you want after updating the data? Merge you meant to say

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

Hi Anil,

I want to merge the new data with old one. But the new data need to be alerted(2 new records which is having unique entry compare to QVD). Please refer the attachment for reference.

Thanks,

Rohit

Kush
MVP
MVP

How would you decide the new records? is based on Product, customer and Purchase?

Not applicable
Author

yes, it is based on three key combination. All the records are unique.

nagarjuna_kotha
Partner
Partner

U can create one flag Like

Today() as Flag

whenever you do reload it create today date as a flag u can concatinate with old one and recently loaded records you can filter it by using date in flag field.

I hope you understood.

-Nagarjun