9 Replies Latest reply: Nov 15, 2012 6:57 AM by Anand Chouhan RSS

    Qlikview Start up question

    Mohanraj Subramanian

      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.

        • Re: Qlikview Start up question
          Kamal Naithani

          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

            • Re: Qlikview Start up question
              Mohanraj Subramanian

              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

                • Re: Qlikview Start up question
                  Kamal Naithani

                  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

              • Re: Qlikview Start up question
                Anand Chouhan

                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

                  • Re: Qlikview Start up question
                    Mohanraj Subramanian

                    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.

                      • Re: Qlikview Start up question
                        Anand Chouhan

                        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