help- how to create a tables

[#1]

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

[nilesh_gangurde]

Heyyy,

         what help you want can you elaborate it ??

Regards,

Nilesh Gangurde

[#3 · Accepted solution]

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.

[jagan]

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.

[#5]

you have all helps me a lot, but i want table that could be updated by clicking on the desired peramter (i.e month, ID etc)

hoe can i accomplish a thing like that?

[jagan]

Hi,

Can you explain in detail about what you require.

Regards,

Jagan.

[#7]

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