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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

creating a flag-field while loading the data

Hi,

I'd like to create a flag-field while loading data based on the condition:

if the value of the resident field 'Quantity'>0, flag=1, else=0.

How is it possible?

Thank you in advance,

Larisa

1 Solution

Accepted Solutions
swuehl
MVP
MVP

LOAD Quantity,

          If(Quantity>0,1,0) as Flag,

          ....

FROM YourTable;

View solution in original post

1 Reply
swuehl
MVP
MVP

LOAD Quantity,

          If(Quantity>0,1,0) as Flag,

          ....

FROM YourTable;