Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Naps_230
Contributor III
Contributor III

How to create field based on other field

Hi All,

I have some data. I need to create field 'Home Away' based on 'Ground' Field .

if Ground out of India it will be Away otherwise Home in script.

 

GroundHome Away
MelbourneAway
ManchesterAway
Lord'sAway
BengaluruHome
DelhiHome

Please any one help me.

1 Reply
YoussefBelloum
Champion
Champion

Hi,

it is better to have/create a field "country" where you can found the Country related to each Ground, like this

Ground               |     Country

Melbourne          |     Australia

Manchester        |     England

Bengaluru          I     India

Delhi                  I     India


then you can do this: If(Country<>'India','Away','Home')


otherwise if you don't have such column, you should hardcod it on the script..