Qlikview Start up question

[mohanrajsubrama]

Hi Guys,

             I am new to Qlikview and i  have couple of question to be solved .Although i worked in tools like Tibco Spotfire .I am being new to this .I know little bit things in qlikview not that much.

so my question in qlikview is

1)Do we want to create 2 qvw files.I mean one for qvd generator and another for loading that qvd files for Reporting purpose?

2)For Every table there much be a Qvd.If i am not wrong we should use that Qvd file for reporting?

3)When we load table or qvd files it gets join Automatically.We dont want to make any joins in the Script?

           Say for example if i am working with a sales database which is having 10 tables in it.

So how should i start that I mean i want to know a better work flow of Qlikview.

Suggestions are appreciated guys

Thanks in Advance

Mohanraj Subramanian.

[kamalqlik · Accepted solution]

Hi Mohan..

Your First question is..

1)Do we want to create 2 qvw files.I mean one for qvd generator and another for loading that qvd files for Reporting purpose?

I think yes.

This is because..qvd generator or raw extractor will hit the database once and will give you the updated QVD's which you can later on use for your reporting.

In case you will directly use them for the Reporting than it will hit the database frequently and the processing for the application will decrease.

With qvd generator you will get the compressed data and which you can easily use in the final application.

2)For Every table there much be a Qvd.If i am not wrong we should use that Qvd file for reporting?

Yes for every table you must have QVD which will be compressed format of data and can be easily used in Reporting

3)When we load table or qvd files it gets join Automatically.We dont want to make any joins in the Script?

That is association between the tables.Moreover you can say that it is like outer join.But in case you want to use left,right,inner etc join .You have to mention that.

Hope it helps

Best Regards

Kamal

[its_anandrjs]

Hi Mohan,

Question wise i suggest you

1)Do we want to create 2 qvw files.I mean one for qvd generator and another for loading that qvd files for Reporting purpose?

Yes usually we create two qvw practice is that when we read data from the database there is some raw data we need to clean it or make another keys ad modified the model also and then according to aour use we created this QVDs and later on nother qvw is used to read this data from qvd and used foe Qlikview Reporting. But always it is not necessary for biig databases it must be a very necessary practice but if the data is small so we are using singe qvw or if we want to create two qvw for that which also a good practice.

2)For Every table there much be a Qvd.If i am not wrong we should use that Qvd file for reporting?

Yes there is for every table there is a QVD but not for every tables like Inline tables, QVD is good for fast data reading from the qvd.

3)When we load table or qvd files it gets join Automatically.We dont want to make any joins in the Script?

It is depend on the Datamodel of the database which requires the different type of joins and concatenation on the table. Joins are created by user but some link is created automatically it depends on the fields.

For sales database  it is not necessary the tables are 10 the no of tables are decrece also depends on the data model of the sales database. Good practice is that define correct Dimensions and Metrics for the reporting in Qlikview.

HTH

Regards,

Anand

[mohanrajsubrama]

Hi Kamal ,

              Thanks for your quick reply.And I have a one more question with this .

   We talked about the 2 qvw files.I mean one for generating qvd's and other one for reporting .

Then how do we get the updated qvd's for reporting?

thanks

mohanraj subramanian

[kamalqlik]

Hi Mohan,

QVD generator will be the generator for all the qvd's

.Let us go with an example.

For example you are having 10 table that are to be used for the reporting.

You will create a QVD generator with help of making connection string to connect through the database.

Use the Store Command in the QVD genertor where you want to store the fetched qvd's in your local.

So when you will reload the application you will get the updated data from table.

For reporting application-You will load the stored qvd's in the application(which are in compressed and updated form).

Regards

Kamal

[mohanrajsubrama]

Hi Anand ,

               Thanks for ur quick reply.Is there any thing to be followed in the Script area while loading the data from datasources like field names.In my tables if 2 or three columns having same name then schema getting scattered.

regards,

mohanraj subramanian.

[mohanrajsubrama]

Hi Kamal,

                 Do we need to reload the qvd generator file (ie) 1st qvw file manually everyday.

or is there any automation process to do this .So 1st qvw file gets updated automatically and we can use the updated qvd's for reporting for the 2nd qvw file.

regards,

mohanraj subramanian.

[kamalqlik]

Hi Mohan,

Yes it is necessary.Because we are extracting the data from database and than using for reporting.

It can be done mannually and also automation wise.

In case you are using the Qlikview server you can go in the reload tab for each application,and set the time when should the application should be reloaded.

In case you are not having a server than you can use the batch file and than go to the control panel and scheduled the task for reload.

regards

Kamal

[mohanrajsubrama]

Hi Kamal ,

                 Thanks for ur suggestion it helped me lot .I think i am ready to try up with this.

Regards,

Mohanraj subramanian.

[its_anandrjs]

Hi,

If there is same  name in the different table in your model so if that keys is not required in differend table so delete them by Delete fieldname or if required that field so rename that fields in different tables so your data model should be correct and normal. While writing the script you should follow any Star Schema or Snow flake Schema for good data models.

HTH

Regards,

Anand