How to create a new field in script and then pull it into a chart
I am still fairly new to QlikView and need help with a simple process.
I have a load script and want to create new fields within the script from the originally loaded fields that I can then use in various charts. I want to simplify the script and need new fields that would be very complex.
I attached the basic script. From this I want to get the following three new fields:
Overtime_Pay = Ovt_Pay_Rate*Ovt_Hrs,
Regular_Pay = Pay_Rate*Regular_Hrs,
Total_Pay = Overtime_Pay + Regular_Pay
How do I create these three new fields and make them available to pull into different charts/graphs.
