Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
nickploeg1998
Contributor
Contributor

Deleting one product

Hii,

I have a column called "VTW nummer", this is like a product.

I have a column called "Financiële consequences", these are the different costs per product. (see Excel)

Now I have all kind of charts and one of the "VTW nummer" is **bleep**ing it all up. So I want to delete (unselect) a "VTW nummer" called "S-VTW-009". So I want to select everything but exclude "S-VTW-009" from the column "VTW nummer".

Is it possible to make a button for this?

Thanks for helping.

2 Replies
miskinmaz
Creator III
Creator III

Hi,
Do you want to ignore the cost of "S-VTW-009" then you can do it from the backend like below:

Load *
from table where not exits(Product,'S-VTW-009');
nickploeg1998
Contributor
Contributor
Author

Yes, but I want to be able to select and unselect it real fast. I want to be able to show what "S-VTW-009" is doing, then turning it off.