Need idea on metrics

[#1]

Need idea on metrics that can be showed using Qlikview

The data is all about the No.of loans originated daily, across region, state, type of loans

Ex:

Date	Region	State	No.of loans	Type of loan
1/1/2011	South	Tamil Nadu	10	Homeloan
1/1/2011	South	Tamil Nadu	4	Personal
1/1/2011	South	Tamil Nadu	5	Education
1/2/2011	South	Tamil Nadu	20	Education
1/3/2011	South	Tamil Nadu	21	Homeloan
1/1/2011	North	Delhi	10	Homeloan
1/1/2011	North	Delhi	8	Personal
1/1/2011	North	Delhi	1	Education
1/2/2011	North	Delhi	2	Education
1/3/2011	North	Delhi	8	Homeloan
1/2/2011	East	WB	6	Education
1/3/2011	East	WB	10	Homeloan
1/1/2011	West	Punjab	9	Education
1/2/2011	West	Punjab	9	Education
1/3/2011	West	Punjab	8	Homeloan

Similarly I have the data for 2 years. So I want how the data can be visualized and show it using qlikview.

[agomes1971]

Hi,

please see the attached and you can another metrics and aproaches...

HTH

André Gomes

[avinashelite]

According to the above data

*Show the number of loans for each Type of loan

*Show the number of loans for each State

*Show the number of loans for each region and Year

[#4]

thanks

I couldnt see the attachment

[#5]

but that could be minimum info abt the data

[agomes1971]

Hi,

use this link

Need idea on metrics

HTH

André Gomes