topic Re: show only null in QlikView

show only null

soha1902 — Wed, 24 Feb 2016 09:03:23 GMT

Hi All,

I want to show only Airline records which has the null #Full Time Employee.

See below image

How do I do this??

Re: show only null

sunny_talwar — Wed, 24 Feb 2016 09:05:11 GMT

In a straight table you can add Airline as dimension and this as your expression:

If(Len(Trim([#Full Time Employee])) = 0, 'Null')

Re: show only null

Wed, 24 Feb 2016 09:05:47 GMT

Hi Soha,

You can achieve len(trim([Part time Employees]))=0

Thanks,

Sreeman

Re: show only null

Chanty4u — Wed, 24 Feb 2016 09:06:26 GMT

hi try dis,

) In Dimension make sure that suppress null values is unchecked for ur dimens.

2) try this expression - Alt(YourExpression,0)

3) In presentation tab uncheck Suppress zero value

Re: show only null

soha1902 — Wed, 24 Feb 2016 09:18:07 GMT

Not working Sunny...

Simply I want to Display 2 columns Airline and #Part Time Employee

And It will display Only Airline Name where Part time Employee value is null

Re: show only null

sunny_talwar — Wed, 24 Feb 2016 09:21:17 GMT

Full time or part time employee?

Re: show only null

Chanty4u — Wed, 24 Feb 2016 09:24:24 GMT

chng exp to this

If(Len(Trim([#Part Time Employee])) = 0, 'Null')

Re: show only null

sunny_talwar — Wed, 24 Feb 2016 09:26:11 GMT

Try this:

Table:

LOAD Airline,

If(Len(Trim([#Full Time Employee])) > 0, [#Full Time Employee]) as [#Full Time Employee],

If(Len(Trim([#Full Time Employee])) > 0, 1, 0) as Flag;

LOAD * Inline [

Airline, #Full Time Employee

ABC Airline,

DEF Airline

GHI Airline, 20

KSL Airline,

SDS Airline, 23

FSS Ainline, 43

];

Re: show only null

soha1902 — Wed, 24 Feb 2016 09:27:23 GMT

Anything we can take but as of now it is showing not null values as a null.

Re: show only null

sunny_talwar — Wed, 24 Feb 2016 09:28:23 GMT

Look at the attached example and see if that helps