Qlik Community

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
babud41
Contributor II
Contributor II

Removing unwanted row in a straight table

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.

 

babud41_0-1634276379593.png

 

Thanks in advance

Dinesh 

QlikView 

1 Solution

Accepted Solutions
AshutoshBhumkar
Partner
Partner

Hello,

You can add below set in your expression.

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

 

Thanks,

Ashutosh

View solution in original post

1 Reply
AshutoshBhumkar
Partner
Partner

Hello,

You can add below set in your expression.

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

 

Thanks,

Ashutosh

View solution in original post