Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Pujitha
Contributor II
Contributor II

Can we add two loads

Hello,

Can we load two loads in the qlikview (edit script) In one sheet I need to work on one fact table (data) in another sheet I need to work on another data file(table).Is that possible??There is No inter relation between the data tables.Please help me.Thanks!!

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

Hi Pujitha

i see a lot of topics you raised recently. You cannot reload for a specific tab it is data modeling issue. You need to model your data properly. If you have 2 facts you have 2 options

- Concatenate the 2 fact tables with a differentiating column e.g. Facttype=tab1, (or fact2)

     - then use this facttype column in your expression set analysis

- create link tables

check below

Fact Table with Mixed Granularity

Generic keys

ogster1974
Partner - Master II
Partner - Master II

Qualify your data on load which will include the table name with the field name so as to keep the two data sets separate then use them as you want in your app.

Or have two apps to keep them seperate. Not sure if your need.

shiveshsingh
Master
Master

Do both the tables have common field names? If yes, you need to modify the column names, and if No, then it should not impact the fact table data.

Let me know in case you need any further clarification.