topic Delete individual data after the script load in QlikView

Delete individual data after the script load

neapicture — Fri, 27 Sep 2019 07:13:55 GMT

Hello everybody,

I want to delete certain records after loading the script 4 or better not even load.

For a record, this works by means of "Where not". How do I do it with 4 records. I can not get that. There are very specific with the appropriate ID ...

If I connect them by means of ContactCodeID = 411 and ContactCodeID = 410 etc. then the whole table is not loaded?

Thanks in advance for the help

Re: Delete individual data after the script load

Arthur_Fong — Fri, 27 Sep 2019 07:31:38 GMT

Try

where not match(ContactCodeID,'411','410');

Re: Delete individual data after the script load

Brett_Bleess — Tue, 08 Oct 2019 13:20:44 GMT

Lutz, did Arthur's post get you what you needed? If so, please be sure to use the Accept as Solution button on his post to give him credit and mark the post as the solution. If you did something different, consider posting that and then use the button to mark it. If you are still working on things, leave an update for us.

One place you can have a look around for ideas is the Design Blog area, lots of how-to related material in this area:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Just use the search box to try to find things, I generally start with a single word and see what comes up there and then use those returns to figure out how to further narrow things down...

Regards,
Brett