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

[PrashantSangle]

Hi,

If want in script

Use Where clause

load * from table

where isnull(skill) or len(trim(skill))=0;

Regards

[anbu1984]

Check this

[#4]

HI Max,

Thanks for your reply, I want to show it in a straight table Like this

RAM	1002		USA
RAM	1003		USA

Regards,

Sruthi

[#5]

Hi, what i need to check, i didn't find any attachment

[PrashantSangle]

Hi,

In straight table write expression,

if(isnull(skill) or len(trim(skill))=0,skill)

check supress null values from Presentation tab

Regards

[#7]

hi

try this in your script

LOAD * Inline [

manager,empid,skill

SHYAM,101,C

SHYAM,102,C++

RAM,1001,JAVA

RAM,1002,

RAM,1003,

]

[Peter_Cammaert]

Or create a flag without changing the actual skill data:

LOAD *, if (len(trim(skill)) = 0, 'N', 'Y') AS skill_flag Inline [

manager,empid,skill

SHYAM,101,C

SHYAM,102,C++

RAM,1001,JAVA

RAM,1002,

RAM,1003,

];

and use set analysis like this in your straight table expression(s):

...{<skill_flag={'N'}>}...

[anbu1984]

Re-attaching QVW

[#10]

HI anbu, I am having the data like this.

LOAD * Inline [

manager,empid,skill

SHYAM,101,C

SHYAM,102,C++

RAM,1001,JAVA

RAM,1002,-

RAM,1003,-]