Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
sagaraperera
Contributor

selection description

Dear ALL

Kindly advice me the command to select the items highlighted below. and name as 'dep'

Please help me.

 

DESCRIPTION
GROSS_PREMIUM
SRCC_PREMIUM
REINSURANCE_FUND
FOREIGN_COMPANIES
CEEDED_PREMIUM
NRP
UPR_CHARGE
NEP
SRCC_TC_COMMISSION
FOREIGN_CO_COMMISSION
COMMISSION_INCOME
NET_REVENUE
GROSS_CLAIMS
CLAIMS_RES_FUND
EXGRATIA_CLIMS_RES_FUND
RI_RECOVERIES_RI_FUND
NET_CLAIMS
COMMISSION_EXPENSES
PRODUCTION_BONUS
DAC_CHARGE
ACQUISITION_COST
GROSS_PROFIT
STAFF_EXPENSES
ADMIN_EXPENSES
SELLING_EXPENSES
DEPRICIATION_EXPENSES
MANAGEMENT_EXPENSES
OTHER_INCOME_EXT
INV_OTHER_INCOME
NET_PROFIT

sagara

3 Replies
MVP
MVP

Re: selection description

Do you mean the accumulated value for all of them should come under description single 'dep'?

sagaraperera
Contributor

Re: selection description

no i want to value separatly

qlikdeez
Valued Contributor

Re: selection description

In load script try:

Load

DESCRIPTION,

if(match(DESCRIPTION,'GROSS_PREMIUM','CEEDED_PREMIUM','NRP','UPR_CHARGE','NEP','NET_REVENUE','NET_CLAIMS','ACQUISITION_COST','GROSS_PROFIT','MANAGEMENT_EXPENSES','INV_OTHER_INCOME','NET_PROFIT'),DESCRIPTION)  as Dep

From ....;

Not sure how that will display on the community but a simpler version:

IF(Match(DESCRIPTION,'ALL','YOUR','VALUES','PASTED','LIKE','THIS'),DESCRIPTION) as Dep

Hope it helps!