Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

Create new field with if logic

Hi Experts,

Can any one please help me to create a new field called

Section with records 'Electronics Section', 'Clothes Section', 'Vehicles Section' from Product, Clothes and Vehicles fields

based on below conditions.

if [Product] is TV,Refrigerator then its  'Electronics Section'

if [Clothes] is Cotton and [Brand] is Asian,Raymond, Allen Solly then its 'Clothes Section'

if [Vehicles] is Car, Bike and Type is Tata,Maruthi then its 'Vehicles Section'

Please help me on this.

Thanks in advance.

3 Replies

Re: Create new field with if logic

Are you looking to create one new field or 3 different fields?

Re: Create new field with if logic

Hi Mahitha, if Product, Clothes, Brand and Vehicles are fields in the same table the sentence, to create the new field it can be:

LOAD

  If(Match(Product, 'TV', 'Refrigerator'), 'Electronics Section',

    If(Clothes='Cotton' and Match(Brand, 'Asian', 'Raymond', 'Allen Solly'), 'Clothes Section',

     If(Match(Vehicles, 'Car', 'Bikes') and Match(Type, 'Tata', 'Maruthi'), 'Vehicles Section'))) as newField,

OtherFields...

From/resident...

mahitham
Contributor

Re: Create new field with if logic

Hi sunny

Based on above conditions need to create one field named section

Community Browser