topic Exclude values in QlikView

Exclude values

Fri, 08 Apr 2011 13:45:43 GMT

Hi,

I have a list of values in a table and a table containing purchases. The connection between these two tables is the invoice number. Now I want to show invoice numbers connected to values except for some values.

One invoice number can have many values.

Say I have this;

invoice_number;value

100200;[1x,2x,3x]
200300,[2x,4x,5y]

The script that I want to write is: set true if invoice_number has the value 2x but not 3x. In this case invoice_number 1 is false and invoice_number 2 is true.

Can this be written with a if-statement or a set analysis?

Exclude values

Fri, 08 Apr 2011 19:42:38 GMT

I would user regular expression for your case; you can see the following post:

http://www.qlikfix.com/2010/10/18/regular-expressions-in-the-load-script/

I will try to come back later with an example.

Otherwise you can you the index function, but the code will not be as straight forward

Exclude values

Tue, 12 Apr 2011 16:04:16 GMT

Thanks, I would appreciate an example. I've looked on the link you sent me but what I understand this regex is not a function within Qlikview but a function that I need to create in VBscript?