Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vikasshana
New Contributor III

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
Esteemed Contributor III

Re: How to add value to an existing field coming from Database

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

Community Browser