How to keep filter for Blank values in Calculation view

[Former Member]

Hi frzz,

Could some one help he how to filter the blank field data.

Ex: Filter out all the employees whose managersID is blank.

Thanks

Krishna.

[rindia · Accepted solution]

Hi Krishna,

For blank, this should work: managersID = ''

(no space)

[Former Member · Accepted solution]

Hi Raj and Krishna,

Thanks for your update.

Actually am filtering it in Projection. When we are filtering on blank we have mention as below.

[rindia · Accepted solution]

try operator as equal to and in value hardcode ''

[Former Member · Accepted solution]

Validation step failed as " Filter on the column  managersID value contains single or double quote"

[rindia · Accepted solution]

When you click on value, can you see the blank value?

[former_member182302 · Accepted solution]

Adding to Raj's comments,

Can you show us the values once? Also as requested can you frame a select statement with the where clause on the table/view and see if it is getting filtered with '' or ' '

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

No Raj. I couldnt see blank value in LOV. But i see the output which filters blank values.

[Former Member · Accepted solution]

Hi Krishna,

I could not find any data when i write SELECT statement with WHERE condition on '' and ' '.

[former_member182302 · Accepted solution]

Then you only have null values right? you dont have any blanks in your data

[Former Member · Accepted solution]

Krishna,

Then you mean when i keep the filter as  below, it will filter null vlaues but not the blank values right??

[former_member182302 · Accepted solution]

No what i meant is DATE_OPEN has only null values , it doesn't have blanks or spaces

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Hi Krishna,

Thank you.

I have a question here. How HANA interprets a Null value with the blank?

[former_member182302 · Accepted solution]

Hi Krishna,

Blanks will show as blank space in the output.

And null means no value, where as blank means value is there and it is blank space

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Yes. You are right Krishna. I have used the below expression in filter. Now its fitered null values as well as blank values.

("managerID" !='') AND (not isNull("managerID" ))

Thank you.

[former_member182302 · Accepted solution]

cool, you used expression editor in projection right? forgot to mention that...

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Yes Krishna. ..

[former_member182302]

Hi Krishna,

blank value can be filtered like managersID = ' '

Regards,

Krishna Tangudu

[Former Member]

Hi Krishna,

Thanks for your reply.

Am using the filter at projection level. But its not filtering the blank data.

[sergey_sheremet]

Hi Krishna,

If you meant that 'blank' is a null value, you should choose IS NULL operator in this dialog.

Good luck!

[former_member182302]

You might have kept the null settings in your studio as BLANK and hence still seeing the blanks in the output.

I'd assume that filtering is happening. Change your null preference settings and check once.

Regards,

Krishna Tangudu

[Former Member]

Hi Krishna,

Wer can i do that setting??

Best Regards,

Krishna.

[former_member182302]

Windows --> Preferences

[Former Member]

Hi Krishna,

I could see the null value maintained as " ? ".

Any idea why the filter is not working out???

Best Regards,

Krishna.

[former_member182302]

Can you frame a select statement on the HANA Model and keep WHERE clause with ' ' and check if it is removing the values?

Also can you share the snapshot of your model.

Regards,

Krishna Tangudu