Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
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.
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.
Heyyy,
what help you want can you elaborate it ??
Regards,
Nilesh Gangurde
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..
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.
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.
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.
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?
Hi,
Can you explain in detail about what you require.
Regards,
Jagan.
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