Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Uploading and updating data files correctly

Hello to all of you.

I am using qlik to get some statistics regarding my hotel (e.g. Occupancy, Average Rates, etc.)

I would like to ask something regarding the data files that are used by Qlik. Basically, what I would like to ask is what is the correct procedure (Step by step) to put the data file in the system. The reason I am asking is because I have created some sheets and programmed several filters etc. and at some time I wanted to replace the data file with an updated one. I obviously did something wrong and every sheet I created was gone so I had to reprogram everything from the beginning. So, in brief what I would like to know is:

1. How can I replace my existing file with a new one without everything being lost?

2. Once I upload the correct file (csv file), If i want to add some additional data to the existing file (e.g. New reservation that I would like to add in the system to update statistics)

Thank you very much all of you. I hope it is clear enough!!!

2 Replies
Specialist II
Specialist II

Everything being lost would be a symptom of different field names.

Even if the data is changing, the names of the fields should remain (or be mapped to) your fields in Sense.

With the possibility of the backend data source changing from file to Excel (or database), it would be best to implement an n-tier architecture where data is loaded from your source into a QVD and that file is loaded into a data model QVD where other QVD sources are (could be) joined and finally your App or UI that binary loads the data model QVD.

This also allows for different developers to work on the various pieces simultaneously.

Your UI App will then be easier to manage keeping the field names the same regardless of the downstream changes.

Contributor
Contributor

Dear David,

Thank you very much for your prompt reply. To be honest with you, this seems very complicated to me. I have nothing more than basic knowledge regarding these staff. Thank you though for your prompt response. I will try to figure out another way that I can work it!!!