topic Re: Comparing/Checking Lines in a Table in QlikView

Comparing/Checking Lines in a Table

mccook — Mon, 24 Feb 2014 16:30:58 GMT

Hi,

I'm looking for a little advice, I have a table kind of like below (but a little more complex)

I have a set of rules:

Rule 1 - Anyone with access to Invoice Entry, Invoice Approval and Invoice Payments (e.g. Dean).

Rule 2 - Anyone with Access to Invoice Entry and Invoice Approval (e.g. Dean and Mark).

How would I go about comparing the lines in the table to identify and display which people are in breach of the rules?

(In the script or a chart, I don't mind)

Cheers,

Dean

nagaiank — Mon, 24 Feb 2014 16:47:17 GMT

You may use And-Mode list box. An example is attached.

mccook — Mon, 24 Feb 2014 17:17:27 GMT

Thats great, thanks.

Is there a way to only show the items selected?

e.g. when I select Invoice Entry and Invoice payments, it shows Invoice Entry, Invoice Payments and Invoice Approval for Dean.

Thanks,

Dean