Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

need answers for this question s

1.How to implement incremental load in the project and what is the scenario?

2. What are the steps involve to handle incremental load in Qlikview?

3. what is the purpose of canateniate tables in Qlikview?

4. In which key we can check after canctenating tables in QVD?

5. How many dashboards we can develop in one project?

6. How many qvw's,screens and sheets we can develop in one project?

7. what is data content file in qvw?

8. How much size of data stored in qvw and qvd?

9. I don't have publlisher then how to transfer qvw files to server?

10. is it possible to store 1GB of data in qvd?

11. How to schedule the file in Qlikview?

12. I need automatic reload in Qlikview, how can i do it? what is the procedure?

13. How can we delete the records in incremental load and what is the purpose of delete? what is the scenario?

2 Replies
cn_sa_dev
Partner - Contributor III
Partner - Contributor III

Hi Mvrchowdary,

You're asking some complicated questions without elaborating much so I hope this helps put you in the right direction:

  1. You need some kind of identifier in the data which can be used to determine if the record has changed or not (an ID, changed date, reference number etc), and use this in the where clause of your load statement.  For more info see:  http://community.qlik.com/docs/DOC-3891
  2. See #1
  3. When you have two tables with the same columns concatenate will put the second table straight below the other (i.e. double the row count).  This is done instead of join which looks for similar fields to join and add columns instead of rows (simplified answer).
  4. Not sure what you mean, but you don't specific field to join on when using concatenate, the column names must just be the same.
  5. There are no specific limits on how many dashboards per model other than aesthetic appeal
  6. There are no specific limits but additional hardware/RAM may be needed for bigger models
  7. Not sure what you mean, Qlikview can read for numerous data sources and can write this data in to a proprietary format called "qvd"
  8. No specific limit besides hardware requirements (see #6)
  9. You don't need publisher to put qvw's on Qlikview Server, just Qlikview Server and you'd normally remote connect to the server
  10. Easily, no problem.
  11. On Qlikview Server you use the Management Console (http://127.0.0.1:4780/qmc/ where 127.0.0.1 is your server's IP Address) to schedule a reload.  Qlikview Server must obviously be installed and setup.
  12. Yes, same approach as above and then you need to specify an automatic loading condition such as a particular time each day or another model dependency
  13. It's not necessary to delete in an incremental load (if I understand your question correctly), you use a condition in the where clause instead to limit it to only the newer records (see #1)

If you find this helpful please mark it as Helpful/Correct answer.

Chris

cn_sa_dev
Partner - Contributor III
Partner - Contributor III

Hi,

If you found this helpful please mark it as "Right Answer" or "Helpful"