1 Reply Latest reply: Nov 6, 2017 12:06 PM by Vishwarath Nagaraju RSS

    How to add value to an existing field coming from Database

    Bharath Vikas Shanagonda

      Hi,

       

      I need your help in one of the requirement. I'm using the below load statement in order to load some data in to the Qlikview.

       

      LOAD 
      IT_SERVICE_COMPONENT_ID as IT_SERVICE_COMPONENT_ID,
      ITSLEVEL5,
      ITSLEVEL6,
      ITSLEVEL7,
      ITSLEVEL8,
      ITSLEVEL9,
      PLADAOWNER,
      if(ITSLEVEL5='HOST IT',ITSLEVEL6) as Serviceorglevel6
      FROM
      X:\QlikView Deployment Files\Navigator\Data\servicehier.qvd
      (
      qvd);

       

      and I'm using Serviceorglevel6 into a list box and below is the output and is coming from Database

       

      Now my requirement is I want another row in the above screen shot as 'Shared Services', How can I add 'Shared Services' with in the Qlikview? The output will be some thing like below.

       

       

      Regards,

      Bharath Vikas