Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pandya__01
Contributor
Contributor

"recovery value" field name not found error occurs

("VolumeFlowRate (Clean) at Reverse Osmosis1 Outlet (Segment1) [m3/h]"/"VolumeFlowRate at RO1 Inlet (Segment1) [m3/h]") AS "recovery value",
(1/(1-"recovery value")) as rec_value

Labels (1)
2 Replies
vinieme12
Champion III
Champion III

You cannot refer a column that is being calculated in the same load , simply because it does not exists until it has been loaded

 

You have 3 options 

1) repeat the calculation for recovery value 

(1/1- ("VolumeFlowRate (Clean) at Reverse Osmosis1 Outlet (Segment1) [m3/h]"/"VolumeFlowRate at RO1 Inlet (Segment1) [m3/h]")) as rec_value

 

2)Use preceding load 

Tablename:

Load 

*,

(1/(1-"recovery value")) as rec_value;

Load 

("VolumeFlowRate (Clean) at Reverse Osmosis1 Outlet (Segment1) [m3/h]"/"VolumeFlowRate at RO1 Inlet (Segment1) [m3/h]") AS "recovery value"

From xxxxxxx;

 

3)Use resident load 

Temp:

Load 

("VolumeFlowRate (Clean) at Reverse Osmosis1 Outlet (Segment1) [m3/h]"/"VolumeFlowRate at RO1 Inlet (Segment1) [m3/h]") AS "recovery value"

From xxxxxxx;

FinalTable:

Load 

*,

(1/(1-"recovery value")) as rec_value

Resident Temp;

Drop table Temp;

 

 

 

 

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

https://youtu.be/Q6CQQ4QCu78 

 

https://qlikviewcookbook.com/2016/04/the-cost-of-preceding-load/

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.