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.
IT_SERVICE_COMPONENT_ID as IT_SERVICE_COMPONENT_ID,
if(ITSLEVEL5='HOST IT',ITSLEVEL6) as Serviceorglevel6
X:\QlikView Deployment Files\Navigator\Data\servicehier.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.