4 Replies Latest reply: Oct 1, 2012 9:23 AM by Alex Finkel RSS

    Renaming either of 2 fields as a new field

    Alex Finkel

      Hi,

       

      New to Qlikview so please bear with me.  As an example of what I'm after, say I have the following fields in my data:

       

      On_Station

      Off_Station

      Change_Station

      Passengers

       

      Where there is an entry in Change_Station I want to use this field.  If there isn't any data in that field I want to use On_station.  I've tried:

       

       

      if(Change_Station=''',On_Station,Change_Station) as BoardingStation

       

      This only brings across the BoardingStation where data is in the Change_Station field.  No doubt I'm making a basic mistake here but any help would be appreciated.

       

      Thanks

      Alex