topic Re: Create a table box based on a condition in QlikView

Create a table box based on a condition

Wed, 25 Nov 2020 16:16:04 GMT

I have two tables for which a created composite keys. Say transaction_id in table 1 and record_id in the table 2.

I need all fields ( in the table box ) from table 1 for which transaction_id is not matched to any of the record_ids.

What would be the best way to do this?

Re: Create a table box based on a condition

sunny_talwar — Fri, 06 Jan 2017 15:07:38 GMT

Can you share how your data model looks like?

Re: Create a table box based on a condition

sunny_talwar — Fri, 06 Jan 2017 15:07:55 GMT

May be a snapshot from your tableviewer in QlikView

Re: Create a table box based on a condition

annafuksa1 — Fri, 06 Jan 2017 15:23:40 GMT

Please look at attached file

Re: Create a table box based on a condition

Fri, 06 Jan 2017 16:38:16 GMT

Sorry Sunny, I am not able to share my data model.

What I am looking for is, I guess, similar to NOT IN clause in SQL.

I would prefere not to do it using resident LOAD as the files are quite large.

Table box is not a mandatory. I can also show it as a straight table as long as this logic can be a part of the expression.

Re: Create a table box based on a condition

annafuksa1 — Fri, 06 Jan 2017 17:08:15 GMT

it is better to use resident load and make all possible calcualtion in Scrript (if reload time is reasonable) as it will not slow downup your app, and do not having complicated formula (as they can significantly slow down application) is quite beneficial.

if you want to use expression use:

only({<transaction_id-= p({1} record_id)>} transaction_id)

Anna