Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Create a table box based on a condition

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?

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

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

View solution in original post

5 Replies
Highlighted

Can you share how your data model looks like?

Highlighted

May be a snapshot from your tableviewer in QlikView

Highlighted
Creator III
Creator III

Please look at attached file

!

Not applicable

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.

Highlighted
Creator III
Creator III

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

View solution in original post