Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

1 Solution

Accepted Solutions
Not applicable

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.

6 Replies
nilesh_gangurde
Not applicable

help- how to create a tables

Heyyy,

         what help you want can you elaborate it ??

Regards,

Nilesh Gangurde

Not applicable

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.

jagan
Not applicable

help- how to create a tables

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.

Not applicable

help- how to create a tables

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
Not applicable

help- how to create a tables

Hi,

Can you explain in detail about what you require.

Regards,

Jagan.

Not applicable

help- how to create a tables

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