Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
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

Re: Create a table box based on a condition

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

Re: Create a table box based on a condition

Can you share how your data model looks like?

Highlighted

Re: Create a table box based on a condition

May be a snapshot from your tableviewer in QlikView

Highlighted
Creator III
Creator III

Re: Create a table box based on a condition

Please look at attached file

!

Highlighted
Not applicable

Re: Create a table box based on a condition

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

Re: Create a table box based on a condition

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