topic Re: RENAMING CLASS CODE in QlikView

RENAMING CLASS CODE

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

Dear Members,

I have list of class codes such as below

CH,PP,SA,HH,M3,M4,MC,MS,TC etc

Out of this list, CH,PP,SA to be re designated as PP & other codes to be remaining as it is. Once this is done the new field created should appear like below

PP,HH,M3,M4,MCMS,TC

Premium under PP,CH & SA should come as an aggregated total under PP class & balance to be shown under other class as they are.

Hope you may send me the formula to be used. I used if match function but my desired out put wont come as it converts all class codes s PP.

Thanks

Re: RENAMING CLASS CODE

nevilledhamsiri — Sun, 04 Aug 2019 15:12:18 GMT

Dear Members,

Please look in to this

Thanks

Neville

Re: RENAMING CLASS CODE

Siva_Sankar — Mon, 05 Aug 2019 06:09:40 GMT

Hi Neville,

Attached example.

Temp:
LOAD CLASS_CODE,
PREMIUM
FROM
C:\Users\A0703003\Downloads\CLASS_CODE.xlsx
(ooxml, embedded labels, table is Sheet1);
NoConcatenate
Fact:
Load
if(CLASS_CODE='CH' or CLASS_CODE='SA','PP',CLASS_CODE) as CLASS_CODE,
PREMIUM
Resident Temp;

Drop table Temp;

Re: RENAMING CLASS CODE

nevilledhamsiri — Tue, 06 Aug 2019 17:12:48 GMT

Thanks siva

Your reply helped me to resolve my issue.

Neville