show only null

[soha1902]

Hi All,

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

See below image

How do I do this??

[sunny_talwar]

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

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

[#3]

Hi Soha,

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

Thanks,

Sreeman

[Chanty4u]

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

[soha1902]

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

[sunny_talwar]

Full time or part time employee?

[Chanty4u]

chng exp to this

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

[sunny_talwar]

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

];

[soha1902]

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

[sunny_talwar]

Look at the attached example and see if that helps