6 Replies Latest reply: Feb 25, 2012 5:19 AM by cachorito RSS

    help- how to create a tables

      hello

       

      i have tables that contain the information about properties rental and the properties them selfs

      i need help in creating a dashboard that will show the number of rental in each country, and in each month and etc

      also i would like to show a graph that shows the total number of rental in a line, the avarge number of rentals and the number of rental by country, property (id) and time period

       

      thank you for your help in advanced

       

      i require to show to my boss the details about our rental DB in the most graphic way.

      i need olap table to show him who are the most active users (travelers and owners)

      also i need dash boards that will show him how many renatls have we had in (months, areas, for a indavduale, and etc)

      i also need to show a graph the will show the avg number of rentals per month and what is the actuale for each month (i would like a line that will show the avg and columns that show the actuale number of rentals)

       

      i hope i made my self clear

      thank you all for preenpts it is very helpful

        • help- how to create a tables
          Nilesh Gangurde

          Heyyy,

           

                   what help you want can you elaborate it ??

           

           

          Regards,

          Nilesh Gangurde

          • help- how to create a tables

            Hi,

             

            Suppose your database has the following fields,

            Prop_Rental

            Rental_ID

            R_Country,

            R_Time,

            Time_Period,

            Property_ID

             

            You could use a cyclic group to work this out..

             

            1. Create a cyclic group…

            To do this, go to Settings-DocProperties-Groups-New-

            //give a group name here like FirstGroupand add the fields you want (like country, month, etc) and click OK--OK.

            1. Right click on Sheet—New Sheet Object—Chart (//giveyour chart a name)—Next—
            2. From the Dimensions page, select the group youjust created (i.e., FirstGroup) and click next.
            3. In theExpression, click on ADD and add the following expressions one by one—
            4. = count(Rental_ID) //total rental IDs --- useR_Country as dimension

             

            For the second graph, create another cyclic group called ‘SecondGroup’with R_Country, Property_ID, Time_Period as fields similarly.

            Once done,  rightclick on the sheet—New Sheet Object—Chart—

            Here, you could use the ‘SecondGroup’ as a dimension.

            Then add the following expressions to the second graph

            =count(Rental_ID) or total(Rental_ID)  //gives the total number of rental

            =avg(Rental_ID)

             

            Hope that helps.

             

            Is that what you are looking for?

             

            Regards,

            -Khaled.

            • help- how to create a tables
              jagan mohan rao appala

              Hi,

              Suppose your table has following columns

               

              PropRental,

              RentalID,

              Country,

              Date,

              PropertyID

               

              Then your script should be

               

              TableName:

              LOAD    

                   PropRental,

                   RentalID,

                   Country,

                   RTime,

                   DateField,

                   Year(DateField) AS Year,

                   MonthName(DateField) AS Month,

                   Week(DateField) AS Week,

                   PropertyID

              FROM DataSource;

               

              Load the data into qlikview.  Now you have Time Period and all required fields.

               

              Now create a new chart, Suppose you need rentals per country, then

              Use Country as Dimension and use =Count(RentalID) as expression.

               

              If you want by Month, then use month as Dimension in chart.

              If you want by PropertyID, then use PropertyID as Dimension in chart.

               

               

              Hope this helps you.

               

              Regards,

              Jagan.