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.

cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik1_User1
Specialist
Specialist

Multiple Data Models in a single app

I have a requirements,  two different apps needs to be merged into a single app.

Fact table from both apps is on same granularity

Below two approaches I am thinking to opt for.

1. Thinking of to concatenate both fact and adding a flag in one fact table.

And In charts related fact 1 or fact 2, will use that flag via set Analysis.Hope that will work.

like Sum({<flag={'fact1'}>}sales)

2. Keep two different data models in single app.

 

Note - Selection of data from charts of datamodel 1 should not impact on charts of datamodel 2

Please suggest if some other approach needs to be considered.

Labels (4)
4 Replies
vinieme12
Champion III
Champion III

By 2 Data models you mean having 2 disconnected models in one app?? that's a VERY BAD IDEA

 

Combining your data into ONE MODEL is the only good option

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Vegar
MVP
MVP

Use your first suggested solution with a concatenated fact table and a flag.

Per default any selection in the common dimensions will affect the "other" data model. You could however keep them apart by inttoducing a second state. Use one state for all fact1 based objects and another state for fact2 based objects.

Read up on Alternate States 

Qlik1_User1
Specialist
Specialist
Author

@Vegar Can you please share some set analysis example how to use Alternate states.

Lets say two alternate states are State1,State2.

Fact 1 set expression - SUM({<status={'true'}>}Sales)

Fact 2 set expression - SUM({<Flag={'fact1'},status={'true'},Ryear=>}Sales)

 

Please suggest how to use the alternate states on above mentioned expression

Vegar
MVP
MVP

Take a look at my simple attached Qlik Sense document. It contains the two states State1 and State2. I created two sheets where one sheet is set to be using State1 the other is using State2. 

Switch between the two sheets and notice that any selection on the State 1 sheet will not affect the data in State 2 sheet.

Vegar_0-1653049117123.png