show only null values

[#1]

Hi all,

I am new to qlikview, i want to show under managers how many employees skill not yet updated.

Can you Please any one help on these

manager	empid	skill
SHYAM	101	C
SHYAM	102	C++
RAM	1001	JAVA
RAM	1002
RAM	1003

Regards,

SRUTHI

[#2]

RAM	1002	-
RAM	1003	-

I want to show like this in straight table,

Thank you.

[PrashantSangle]

Hi,

In straight table write expression,

if(isnull(skill) or len(trim(skill))=0 or match(skill,chr(45)),skill)

check supress null values from Presentation tab

Regards

[richard_chilvers]

Agreed, Peter.

This type of requirement with null values pops up all the time, and having tried several approaches, the one you suggest (where a null value is given a 'proper' value) seems to work best.

[#5]

Hi Sruthi,

try this in your script

LOAD * INLINE [

    manager, empid, skill

    SHYAM, 101, C

    SHYAM, 102, C++

    RAM, 1001, JAVA

    RAM, 1002

    RAM, 1003

] where  Len(Trim(skill))=0;

After this add fields in staright table will display only missing values of skills one.

[Peter_Cammaert]

There is an even better approach which may not apply to this case; very often, NULL values are unwanted and indicate data that shouldn't be missing at all. A translation technique like:

... if (len(trim(skill)) = 0, '**UNASSIGNED**', skill) AS skill, ...

will prove to be a lieutenants best drill-sergeant...

[richard_chilvers]

Yes, indeed. Been tripped up in that way a few times before now !

[anbu1984]

Check this app

[qlikview979]

Hi Sruthi,

May be this

T1:

LOAD * Inline [

manager,empid,skill

SHYAM,101,C

SHYAM,102,C++

RAM,1001,JAVA

RAM,1002,-

RAM,1003,-];

NoConcatenate

T2:

load

manager,empid,skill

Resident T1 where Match(skill,'-') ;

DROP Table T1;

In straight table

Dimension:-manager,empid

Expression:-skill

[passionate]

Hi Shruti,

Try Using this in your load script:

LOAD manager,

     empid,

     skill,

     If(Len(skill)=0,'-',0) as NotSkilled

FROM

(ooxml, embedded labels, table is Sheet1);

In Straight Table use:

Dimension1: manager

Dimension2: EmpId

Expression : NotSkilled

Regards,

Pankaj

[abc_18]

/*shows only Null values*/

temp:

LOAD manager,

     empid,

     If(Len(skill)=0,'-',0) as NoSkill

FROM

(ooxml, embedded labels, table is Sheet1);

/*show only nonnull values*/

temp:

LOAD manager,

     empid,

     If(IsNull(skill),0,skill) as Skilled

FROM

(ooxml, embedded labels, table is Sheet1);