Discussion board where members can get started with QlikView.
I've a Sales table which contains all the customers which have shipments. But not all the customers. I would add to this table all the customers without shipment.
Type , all the other fields
load Customer from MY_MASTER_DATA ....
where not exists(Customer);
but it doesn't produce anything.
What I'm doing wrong ?
Try like this
where not exists(Customer,Customer);
Hope it helps
Unfortunatly it doesn't work.
I don't know why
Mayil suggestion is correct Otherwise Can u provide a sample file to solve ur requirments.
I found the problem: it was my mistake, I dropped the second table and I didn't see the right result.
I'm sorry and thanks to everyone who spent time to help me.
What I know now, is that the "added" records are only in memory. Wanting to have a physical table with all the records, what should I do ?
Thanks for your help
You can store the table you just created by concatenation into a qvd file.
Use the STORE keyword for this.
Try something like :
Store Shipmenttable into Shipmenttable.qvd (qvd);
This will generate a QVD file for your result table.
Alternatively, you can just add all the fields from Shipmenttable into a table box and export it to Excel.
Hope that helps.
Perhaps I'm making some mistake, but after the storing and reload of the final table, I don't see the added records inside.
Your script should look something like this:
rowno() as S.No
Resident WithoutShipments where Exists(Customer,Customer);