Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

how do i seperate M and F on field Gender to different fields

Hello Peeps,

I want to seperate M and F to different fields, so i can load to different listbox.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

In script try like this

Data:

LOAD

*,

If(DimensionName = 'M', DimensionName ) AS DimM,

If(DimensionName = 'F', DimensionName ) AS DimF

FROM DataSource;

Note : Replace DimensionName with your actual field name.

Hope this helps you.

Regards,

jagan.

View solution in original post

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

In script try like this

Data:

LOAD

*,

If(DimensionName = 'M', DimensionName ) AS DimM,

If(DimensionName = 'F', DimensionName ) AS DimF

FROM DataSource;

Note : Replace DimensionName with your actual field name.

Hope this helps you.

Regards,

jagan.

View solution in original post