Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
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 🙂