Eliminate Null/Blank values in AdHoc Qliksense

[smanas]

Hi I'm trying elimiate NULL/Blank Values in AdHoc QlikSense Please advise an expression.

Only the one with the below criteria should appear.

1. ID with Start date but no date date/Blank is Ok

2. ID with No start date but end date is not OK

3. ID with No start and No end date/Blank is not OK

ID	Start Date	End Date
1	-	-
1	-	01/03/2078
1	-	-
2	-	-
2	01/02/2022	01/01/2023
3	05/02/2022	-
3	-	-

[neerajthakur]

In Table there is Data option there you can unselect Include null values or to remove it from backend write where statement

where not isnull("Start Date");

[smanas]

Thank you @neerajthakur  it is returning a -1 against each ID If I use - Not isNull("Start Date")

[smanas]

Thank you @neerajthakur it's giving me a -1 when I add the above expression.

[neerajthakur]

Use this statement in load editor do you have these fields there or you are calculating it on frontend

You can use this also where isnull("Start Date")=0

[smanas]

Hi @neerajthakur I'm not using any script I'm only using an Adhoc query.