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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load field and change data

I have a database with a field (sex) consisting of two characters M or F (male and female).

In the load I´d like to change the F to W, -

is it possible to make somtheing like

LOAD [sex],

if ([sex]=F), M) as sexA

Or maybe a better solution??????

0 Replies