topic highlight keys that dont match and throw exception in QlikView

highlight keys that dont match and throw exception

Sat, 26 Oct 2013 08:46:02 GMT

Hi!

I have two tables.

1. Master - Defines the Items allowed

2. Trans - The transaction on item level.

If the transaction is filled in incorrectly, and the Item number does not match the Master item, how can i throw an exception so that the user is aware.

i was imaging a popup window (visualization) based on a condition like match or can this be caught at load time and throw an error?

my application is attached below.

Best

Brad

Re: highlight keys that dont match and throw exception

swuehl — Sat, 26 Oct 2013 10:42:23 GMT

You can use exists() funtion to check on field value already exists in Master table.

Maybe like attached (using an invalid statement to throw an error on load).

Re: highlight keys that dont match and throw exception

marcus_sommer — Sat, 26 Oct 2013 10:44:37 GMT

You could load your transaction with a where-clause with exists(item) but then you or your user don't know if there are incorrect data. Perhaps it is better you make a mapping with applymap - if(applymap('master', item, 'error') = 'error', 'incorrect data', 'correct data') as ErrorFlagField - and you can switch per selection between them.

- Marcus