topic Re: How to add a new input field dimension in QlikView

How to add a new input field dimension

Anonymous — Thu, 13 Nov 2014 22:27:31 GMT

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?

Tks.

Re: How to add a new input field dimension

jduenyas — Thu, 13 Nov 2014 22:54:40 GMT

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