Partial reload script return null value

paulyeo11 — Thu, 03 Oct 2019 06:43:44 GMT

Hi All

I have a field = GP_TYPE_ from Mapping :-

ApplyMap('MapGroupType',@43:48T,@307:314T) AS GP_TYPE_,

Which have value label from 1 to 16

i Need to recode
1 to G01-GT
2 to G02-AP
3 to G03-SL
4 to G04-CL

AND SO ON .....

So i use the below script for partal reload to get field GROUP_TYPE_ :-

sales_G:

LOAD GROUP_CLASS,SOURCE,

if (GP_TYPE_='1' ,'G01-GT',
if (GP_TYPE_='2' ,'G02-AP',
if (GP_TYPE_='3' ,'G03-SL',
if (GP_TYPE_='4' ,'G04-CL',
if (GP_TYPE_='5' ,'G05-RW',
if (GP_TYPE_='6' ,'G16-PG',
if (GP_TYPE_='7' ,'G07-BP',
if (GP_TYPE_='8' ,'G08-KL',
if (GP_TYPE_='9' ,'G09-TH',
if (GP_TYPE_='10' ,'G12-EX',
if (GP_TYPE_='11' ,'G12-EX',
if (GP_TYPE_='12' ,'G13-ID',
if (GP_TYPE_='16' ,'G06-AO',
))))))))))))) as [GROUP_TYPE_]

resident sales;

When i reload i don't get any error , but the field name GROUP_TYPE_ return null value. I am stuck here.

Paul Yeo

Re: Partial reload script return null value

paulyeo11 — Thu, 03 Oct 2019 06:56:12 GMT

Hi All

Enclosed my QVW

Alternative , can some one share with me , with out using partial reload , how to modify the below script , so that it will display :-

ApplyMap('MapGroupType',@43:48T,@307:314T) AS GP_TYPE_,

1 display G1

2 display G2

3 display G3

4 display G4

Just need to add a G infront of number.

Paul

topic Re: Partial reload script return null value in QlikView

Partial reload script return null value

Re: Partial reload script return null value