Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
KayPong
Contributor II
Contributor II

Field cannot be found when trying to load the script

When I am trying to load Line Y in the following script in the Load Script Editor, I am returned with an error that [KPI.Target] cannot be found  whereas Line X is perfectly ok without the presence of Line Y. May I have your advice on what I had done incorrectly?

 

 

[Overview]:

Load
[KPI Key]
, [KPI.Target] as [Target] //Line X
, [KPI.Threshold] as [Threshold]

Resident [KPI];
drop Tables [KPI];

Left Join ([Overview])

Load
[KPI Key]
,sum([A.Case - Dengue])/$(vPopYear)*100000 as [Measurement]
,if( sum([A.Case - Dengue])/$(vPopYear)*100000 < [KPI.Target] , 1, 0) as [Green]  // Line Y

resident [A]
group by [KPI Key];

 

 

Labels (3)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

You are loading resident from table [A]. You give us no further info about this table. Have you checked that this table contains the KPI.Target field ? 

View solution in original post

6 Replies
KayPong
Contributor II
Contributor II
Author

Can someone provide me some light to the above? thank you!

 

brunobertels
Master
Master

Hi

 

you rename KPI.Target as Target , but call in your left join KPI.target 

try to change your mesure :

,if( sum([A.Case - Dengue])/$(vPopYear)*100000 < [Target] , 1, 0) as [Green]  // Line Y

[Overview]:

Load
[KPI Key]
, [KPI.Target] as [Target] //Line X
, [KPI.Threshold] as [Threshold]

Resident [KPI];
drop Tables [KPI];

Left Join ([Overview])

Load
[KPI Key]
,sum([A.Case - Dengue])/$(vPopYear)*100000 as [Measurement]
,if( sum([A.Case - Dengue])/$(vPopYear)*100000 < [KPI.Target] , 1, 0) as [Green]  // Line Y

resident [A]
group by [KPI Key];

Kushal_Chawda

You have renamed the [KPI.Target] in line X so in Line Y you need to provide the renamed field name which is  "Target"

KayPong
Contributor II
Contributor II
Author

I still get returned with an error that Target is not found when I changed Line Y to the following 

,if( sum([A.Case - Dengue])/$(vPopYear)*100000 < [Target] , 1, 0) as [Green] 

Vegar
MVP
MVP

You are loading resident from table [A]. You give us no further info about this table. Have you checked that this table contains the KPI.Target field ? 

KayPong
Contributor II
Contributor II
Author

Thanks Vegar.

Yes the problem lies in table A must contain KPI.Target which previously it was not there. I have used a temporary table to join it and now it works.