Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Lionel_Maximus
Contributor III
Contributor III

Adding Flag in a table

Hello,

I have two FACT tables and they contain  several common fields i want to concatenate both of them but using Flags so the result won't be affected on the same selection.....Can anyone tell me how to do that???

Regards

1 Solution

Accepted Solutions
Vegar
MVP
MVP

You can use SET analysis to limit your calculations to one  data set.

 

FACT:
LOAD *, 'Fact1' as _factSource FROM fact1DataSource;
Concatenate (FACT) LOAD *, 'Fact2' as _factSource FROM fact2DataSource;

In your expressions you may use expressions like I've done below for a Fact2-calculation of the Amount field

=SUM( {<_factSource = {'Fact2'}>} Amount)

View solution in original post

2 Replies
Vegar
MVP
MVP

You can use SET analysis to limit your calculations to one  data set.

 

FACT:
LOAD *, 'Fact1' as _factSource FROM fact1DataSource;
Concatenate (FACT) LOAD *, 'Fact2' as _factSource FROM fact2DataSource;

In your expressions you may use expressions like I've done below for a Fact2-calculation of the Amount field

=SUM( {<_factSource = {'Fact2'}>} Amount)
Lionel_Maximus
Contributor III
Contributor III
Author

Thank You 🙂