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: 
rickrogers
Contributor II
Contributor II

Create new field then create another field based on new field

How can I create a calculated field from a calculated field in the same load statement? 

LOAD
[Item No],
[Cost Amount]
[Sales Amount],
[Invoiced Quantity],
[Size UOM],


[Invoiced Quantity]/[Size UOM] as [Result]

If (Match ( [Result], >1,000 ) , Accurate, Not Accurate) as [Position]

 

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

[Invoiced Quantity]/[Size UOM] as [Result]

If ( Invoiced Quantity]/[Size UOM] >1,000 ) , Accurate, Not Accurate) as [Position]

 

or use preceeding load:

LOAD
    *,
   If ( Result>1,000 ) , Accurate, Not Accurate) as [Position];
LOAD
[Item No],
[Cost Amount]
[Sales Amount],
[Invoiced Quantity],
[Size UOM],


[Invoiced Quantity]/[Size UOM] as [Result]

View solution in original post

1 Reply
m_woolf
Master II
Master II

[Invoiced Quantity]/[Size UOM] as [Result]

If ( Invoiced Quantity]/[Size UOM] >1,000 ) , Accurate, Not Accurate) as [Position]

 

or use preceeding load:

LOAD
    *,
   If ( Result>1,000 ) , Accurate, Not Accurate) as [Position];
LOAD
[Item No],
[Cost Amount]
[Sales Amount],
[Invoiced Quantity],
[Size UOM],


[Invoiced Quantity]/[Size UOM] as [Result]