Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Replacing Null

Hi

I have a Table like below :

AGENTID

LEID
1TN31Q8429
2-
3-
4
5TN31Q8433
6TN31Q8434
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

4 Replies
vishalwaghole
Valued Contributor II

Re: Replacing Null

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

MVP
MVP

Re: Replacing Null

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; 

yousef_am
Contributor II

Re: Replacing Null

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

c_gilbert
Contributor II

Re: Replacing Null

Could you just display them differently in the Presentation tab?

QV_null_missing.png

Community Browser