Suppose your database has the following fields,
You could use a cyclic group to work this out..
- 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.
- Right click on Sheet—New Sheet Object—Chart (//giveyour chart a name)—Next—
- From the Dimensions page, select the group youjust created (i.e., FirstGroup) and click next.
- In theExpression, click on ADD and add the following expressions one by one—
- = 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
Hope that helps.
Is that what you are looking for?
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
Suppose your table has following columns
Then your script should be
Year(DateField) AS Year,
MonthName(DateField) AS Month,
Week(DateField) AS Week,
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.