Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
rickrogers
New Contributor

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
mwoolf
Honored Contributor II

Re: Create new field then create another field based on new field

[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
mwoolf
Honored Contributor II

Re: Create new field then create another field based on new field

[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