Created Fields in Data Load Editor, but They're Not Being Recognized in the Analysis Sheet

[MTS95]

Hi there,

I'm having a bit of a time getting Qlik to recognize some fields I thought I created. I've attached some screenshots here, and I'll try to articulate the issue as best I can.

My office created some script in an app that gives us the churn rate of customers (that is, a rate of the customers lost from the previous year).  It works perfectly, but when I take that script and put it into a different app in the same work stream, Qlik does not seem to recognize some of the fields that were successfully created.

For example, we created the fields peekyear and peekCID using some other fields that had been previously loaded, but notice in the screenshots below that they are not highlighted in gold like field names might normally be.

This problem might have more to do with the issues that might arise when I copied the script from one app to the next rather than a syntax error, but any guidance you can offer is appreciated. Please let me know if I need to clarify anything or add more information, and thank you for your help!

Screenshot 1: The expression field I'm attempting to use to create a KPI for churn rate.

Screenshot 2: A portion of the data load editor page where the fields we created are highlighted in gold.

[vinieme12]

1) Check for  any  Drop Field  statements later in the script

2) if you are doing a resident loaded from [sales b] later in the script are you making sure you load  peekyear and peekcid ??

It's very hard to tell with just a portion of the script, can you post the entire script?

but it could be either  one  of the two reasons mentioned above

[MTS95]

Certainly; I've attached the script in its entirety below.

Some sections were commented out because I had been going through and trying to take out any sections that the Qlik output had an issue with--I was not the one to write the code initially, so I was trying to take out things that weren't working. The full script below has the things I commented out put back.

I should elaborate that I (sort of) solved my initial problem by taking lines 19 through 25 and inserting them into the LOAD section of the other app. If it's helpful, here is that script (sorry if I'm throwing a lot into this forum all at once, feel free to ignore this part if it turns out to not be relevant):

Thank you for helping!!