Hello! I'd like to create a new dimension "Target" where I can input the target qty (based on Vendor Name, Type and Module Density).. My object is to calculation the difference between Target and Open Qty. I prefer not to create a variable or input box since I will be entering around more than 20 targets every quarter. Is this poccible to do it in scripts?
Add a table based on VendorID (or name if they are unique) with 2 fields, VendorID and the Target you wish for the vendor. The table Open PO should then link on the VendorName (or ID) and then you can add the measure of target v Open Qty.
That is of course if you will be updating the Vendors and their Target values outside of QlikView
