Search box is displaying blank value when there are no NULL values

[Anonymous]

Hi,

Search box is displaying blank value when there are no NULL values.

Attached is the sample QVW.

Can someone please help me asap.

Thanks!

[maxgro]

The attachment is the log not the qvw

[Anonymous]

Apologies.

Added the QVW now.

[sunny_talwar · Accepted solution]

Try with this Where statement

Where Len(Trim(KeepChar(Upper(PARENT_FIRM_NAME), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ&.-1234567890 ')))>0 ;

[Anonymous]

Thanks a lot Sunny!

[svinnakota]

Hello Roshitha,

You can trying one more filter condition:

where

KeepChar(Upper(PARENT_FIRM_NAME), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ&.-1234567890 ') <>''

I guess the reason is the entire value is getting purged when you are using Keepchar function. In that place blank values appears.

Please correct me,if i am wrong in my assumption.