topic help- how to create a tables in QlikView

help- how to create a tables

Fri, 24 Feb 2012 21:59:19 GMT

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 — Sat, 25 Feb 2012 07:32:48 GMT

Heyyy,

what help you want can you elaborate it ??

Regards,

Nilesh Gangurde

help- how to create a tables

Sat, 25 Feb 2012 08:17:55 GMT

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..

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

=avg(Rental_ID)

Hope that helps.

Is that what you are looking for?

Regards,

-Khaled.

help- how to create a tables

jagan — Sat, 25 Feb 2012 09:45:46 GMT

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.

help- how to create a tables

Sat, 25 Feb 2012 10:05:53 GMT

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?

help- how to create a tables

jagan — Sat, 25 Feb 2012 10:08:52 GMT

Hi,

Can you explain in detail about what you require.

Regards,

Jagan.

help- how to create a tables

Sat, 25 Feb 2012 10:19:45 GMT

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 hope i made my self clear

thank you all for preenpts it is very helpful