topic Re: Replacing Null in QlikView

Replacing Null

Thu, 31 Jul 2014 07:36:39 GMT

I have a Table like below :

AGENTID	LEID
1	TN31Q8429
2	-
3	-
4
5	TN31Q8433
6	TN31Q8434
7
8
9
10	TN31Q8438

I want to display a chart , if there is a value in LEIID , then its 'available' , if no value (Which includes -)'Missing'

How to achieve it

Re: Replacing Null

VishalWaghole — Thu, 31 Jul 2014 08:04:29 GMT

Hi,

Try this,

Test:

LOAD * Inline [

AGENTID, LEID

1, TN31Q8429

2, -

3, -

4, -

5, TN31Q8433

6, TN31Q8434

7, -

8, -

9, -

10, TN31Q8438

];

LOAD *,

if(Match(LEID,'-'),'Missing','Available') as Flag

Resident Test;

and also find attached application

-- Regards,

Vishal Waghole

Re: Replacing Null

tresB — Thu, 31 Jul 2014 08:15:33 GMT

If you are talking about handling nothing(space or so) and '-' together, try like:

Test:
LOAD * Inline [
AGENTID, LEID
1, TN31Q8429
2, -
3, -
4, -
5, TN31Q8433
6, TN31Q8434
7,
8,
9,
10, TN31Q8438
];

LOAD *,
if(Match(LEID,'-') or Len(Trim(LEID))=0,'Missing','Available') as Flag
Resident Test;

Re: Replacing Null

Yousef_Amarneh — Thu, 31 Jul 2014 08:24:38 GMT

if(IsNull(LEID),'Missing','Available')

Re: Replacing Null

c_gilbert — Thu, 31 Jul 2014 08:30:36 GMT

Could you just display them differently in the Presentation tab?