Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
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.
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.