Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a field in the data load editor that is based on a condition of other loaded fields. the data base is about chess, my goal is to find the gap in ratings for each game ive loaded. i am wanting to write a condition as follows
if black is winner than (black_rating - white_rating), if white is winner than (white_rating - black_rating)
fyi: existing relevent fields
winner (possible values are black, white)
White_rating (eg. 1400)
Black_rating (eg. 1600)
If(winner='black', Black_rating - White_rating, White_rating - Black_rating) as Rating_Delta
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
If(winner='black', Black_rating - White_rating, White_rating - Black_rating) as Rating_Delta
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com