Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasshana
Creator II
Creator II

How to add value to an existing field coming from Database

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

1 Reply
vishsaggi
Champion III
Champion III

What is that you want to display for your SharedServices field?