topic Re: why my load script last line not work ? in QlikView

why my load script last line not work ?

paulyeo11 — Fri, 19 Jan 2018 01:37:59 GMT

Hi All

I have a field on sales stage the label very long , i like to shorten it :-

Replace([Opportunities Sales Stage],' ','_') as [Sales Stage],

Closed_Lost

Closed_Won

Commitment_to_Buy

Initial_Communication

Needs_Assessment

Negotiation

Pending

Prospecting

Sales_Fulfillment

So i create a new script :-

if([Opportunities Sales Stage]='Closed Lost', '8C_LOST',

if([Opportunities Sales Stage]='Closed Won', '9C_WON',

if([Opportunities Sales Stage]='Commitment to Buy', '5_COM2BUY',

if([Opportunities Sales Stage]='Initial Communication', '1INT_COM',

if([Opportunities Sales Stage]='Needs Assessment', '2NEED_AS',

if([Opportunities Sales Stage]='Negotiation', '4NEGO',

if([Opportunities Sales Stage]='Pending', '6PENDING',

if([Opportunities Sales Stage]='Prospecting', '3PROPOSE',

if([Opportunities Sales Stage]='Sales_Fulfillment', '7SALE_FULL',

))))))))) as [Sales Stage],

My above load script work fine for all label , except below linie :-

if([Opportunities Sales Stage]='Sales_Fulfillment', '7SALE_FULL',

it just display record the Sales_Fullfillment into 7SALES_FULL

Paul

Re: why my load script last line not work ?

paulyeo11 — Fri, 19 Jan 2018 01:40:55 GMT

Hi All

I found the error , after i remove the "_" from Sales_Fulfillment it work.

Thank

Paul

Re: why my load script last line not work ?

prma7799 — Fri, 19 Jan 2018 04:16:48 GMT

in [Opportunities Sales Stage] field have any value like Sales_Fulfillment

Re: why my load script last line not work ?

paulyeo11 — Fri, 19 Jan 2018 04:20:48 GMT

Hi PM

now already solve.

Before is :-

Sales_Fulfillment

After i change to below , it work fine :-

Sales Fulfillment

Thank

Paul

Re: why my load script last line not work ?

prma7799 — Fri, 19 Jan 2018 04:27:10 GMT

okies

in that _ is not there...