Inline table with Any or Null values

terezagr — Tue, 18 Nov 2014 10:03:32 GMT

Hi all,

I have been trying to create an Inline table where in Dec_Code can be any combination, or a specific value from Dec_Code. In Dec_Resp_Code can be a specific value from Dec_Resp_Code, or the field is blank().

APPS:

Load

DEC_RESP_CODE,

DEC_CODE

From APPS.qvd(qvd);

left join (APPS)

LOAD * INLINE [

DEC_RESP_CODE, DEC_CODE, OFFER_TYPE, OFFER_CATEGORY

U, Any value , UN OFFER, DECLINE

Blank , P, TOTALS, PENDING

];

I have tried with no luck:

//first set null interpreter to the string: NULL

SET Nulldisplay =' ';

LOAD * INLINE [

DEC_RESP_CODE, DEC_CODE, OFFER_TYPE, OFFER_CATEGORY

U,DEC_CODE , UN OFFER, DECLINE

, P, TOTALS, PENDING

];

//reset null interpreter

SET Nulldisplay =;

Any suggestions?

Re: Inline table with Any or Null values

terezagr — Thu, 27 Nov 2014 10:54:01 GMT

I have solved this issue. The solution is below:

APPS:

Load

DEC_RESP_CODE as DEC_RESP_CODE_ORIGINAL,

if(IsNull(DEC_RESP_CODE) and DEC_CODE='1P','1P',

if(IsNull(DEC_RESP_CODE) and DEC_CODE='W','1W',

DEC_RESP_CODE)) as DEC_RESP_CODE,

DEC_CODE

from APPS.qvd(qvd);

left join (APPS)

LOAD * INLINE [

DEC_RESP_CODE, OFFER_TYPE, OFFER_CATEGORY

U, UN OFFER, DECLINE

1P , TOTALS, PENDING

1W, TOTALS, PENDING

];

topic Re: Inline table with Any or Null values in QlikView

Inline table with Any or Null values

Re: Inline table with Any or Null values