Discussion board where members can get started with QlikView.
Hi Everyone Special,
I have a new problem at which I am stuck at the moment.
A. I have a field called MPN in two separate qvds- say qvd A and qvd B. MPN holds product number.
Over the period there are many product which gets cancelled.
QVD A stores the history and the QVD B stores the current records.
So there are cases in which MPN has product numbers in QVD A but as the product got cancelled so the MPN field in QVD B won't be having
any of those product number. The requirement calls them deleted items.
Now the task is to find how many of such product number got deleted over the period.
Thanks beforehand and I really appreciate your time and effort,
Plz find the attachment....
Hope it solves ur purpose...
if u can't open the file then refer this:
LOAD * INLINE [
MPN1 as MPN
drop table BB;
In front End:
To count deleted items:
To find deleted Items:
=if(MPN<>MPN1,MPN) in list box.