Removing unwanted row in a straight table

[babud41]

Hi all,

I want to remove the unwanted rows in a straight table where the column values on "ne" column is like "%results%" 

I will attach the picture here.

Thanks in advance

Dinesh 

QlikView 

[AshutoshBhumkar · Accepted solution]

Hello,

You can add below set in your expression.

Sum({<ne -= {"*results*"}>}Sales)

Thanks,

Ashutosh