# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Excluding NULL & -ve Values

Hi,

I am trying to do set analysis in Strange table to exclude date which are blank & Day Rem which are in negative.

=Count({<[User ID]={'=Len(Trim([Complete Date]))=0'},[Days Rem]={"<=0"}>}[User ID])

But in not get required result.

1 Solution

Accepted Solutions
MVP

## Re: Excluding NULL & -ve Values

Your field name is Completed Date and not complete date

=Count({<[User ID]={"=Len(Trim([Completed Date]))=0"},[Day Rem]={"<=0"}>}[User ID])

10 Replies
Valued Contributor

## Re: Excluding NULL & -ve Values

May be this

Count({<[User ID]-={'=Len(Trim([Complete Date]))=0'},[Days Rem]-={"<=0"}>}[User ID])

MVP

## Re: Excluding NULL & -ve Values

May be this

=Count({<[User ID] = {"=Len(Trim([Complete Date]))>0"}, [Days Rem]={">0"}>} [User ID])

Contributor

## Re: Excluding NULL & -ve Values

No Result

Example Data

 User ID Completed Date Day Rem 123 1-Dec-16 50 124 30 125 1-Dec-16 20 126 -2 127 -4 128 1-Dec-16 0 129 0 130 1-Dec-16 0 131 -48

I Need count as 4

 User ID Completed Date Day Rem 126 -2 127 -4 129 0 131 -48
Valued Contributor III

## Re: Excluding NULL & -ve Values

is your [Days Rem] field really numerical?

you could try

...

num(num#([Days Rem])) as [Days Rem],

...

Contributor

## Re: Excluding NULL & -ve Values

Yes I did converted dates to dated format and number to number format.

MVP

## Re: Excluding NULL & -ve Values

Would you be able to share your app?

Valued Contributor III

## Re: Excluding NULL & -ve Values

does every "User ID" have exactly 1 "completed Date"?

Contributor

## Re: Excluding NULL & -ve Values

Please find App And Excel File.

MVP

## Re: Excluding NULL & -ve Values

Your field name is Completed Date and not complete date

=Count({<[User ID]={"=Len(Trim([Completed Date]))=0"},[Day Rem]={"<=0"}>}[User ID])