topic Re: selection description in QlikView

selection description

sagaraperera — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: selection description

tresB — Fri, 18 Nov 2016 09:38:42 GMT

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

Re: selection description

sagaraperera — Fri, 18 Nov 2016 09:52:32 GMT

no i want to value separatly

Re: selection description

Anonymous — Fri, 18 Nov 2016 11:45:21 GMT

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!