topic Re: KPIs of Sales Dashboard for real estate company in QlikView

KPIs of Sales Dashboard for real estate company

dsdeepak284 — Wed, 25 Nov 2020 16:16:04 GMT

Hi can anyone suggest me the best kpis of the Sales Dashboard for real estate company. Its urgent

Re: KPIs of Sales Dashboard for real estate company

MK9885 — Wed, 06 Dec 2017 19:01:37 GMT

Find the Qlik example attachment.

You can probably use the KPI's from to show profit or loss, depending on what you want.

Like tracking the progress.

Look out for more examples on Qlik Demos

Re: KPIs of Sales Dashboard for real estate company

dsdeepak284 — Mon, 11 Dec 2017 15:09:40 GMT

Please suggest 4-5 major kpis for the sales dashboard of real estate company, for qlikview dashboard.

Re: KPIs of Sales Dashboard for real estate company

MK9885 — Mon, 11 Dec 2017 17:42:07 GMT

Sum(Sales)- Total Sales

sum({<Year={2012}>} Sales)-sum({<Year={2013}>} Sales)-- Yearly Sales Comparision

sum({< Year = {$(=Max(Year))}>} Sales)-- Max Year Total Sales

It can be more but what Dimensions you've and how you like to show sales?

Region/State/City or Real Estate names etc.... ?

Please tell us your Dimensions and if you have any Dates also available in your Data

Re: KPIs of Sales Dashboard for real estate company

dsdeepak284 — Tue, 12 Dec 2017 00:26:05 GMT

I have the last 3 years data with date details for a sales dashboard of real estate company, I have to present the sales dashboard with this data, the dimensions are i have like region, state, city, sales, type of Apartments, sales person name.

And also help me to calculate sales by region.

Re: KPIs of Sales Dashboard for real estate company

MK9885 — Tue, 12 Dec 2017 19:23:13 GMT

1st KPI

=' Sales % by Year '&

if(GetSelectedCount(Year)=0,

num(sum(Sales)/sum({<Year = {$(=Max(Year))} >} Sales),'$#,##0.00') & chr(10),

num(sum(Sales)/sum({< Year >} Sales)/100,'#.00%')& chr(10))

2nd KPI

=' Sales difference by Year '&

if(GetSelectedCount(Year)=0,

num(sum(Sales)-sum({<Year = {$(=Max(Year))} >} Sales),'$#,##0.00') & chr(10),

num(sum(Sales)-sum({<Year >} Sales),'$#,##0.00') & chr(10))

3rd KPI

=' Total Sales '& num(sum(Sales),'$#,##0.00')& chr(10)

This can be further improved as these are basic KPI's. Alternate states can also be used to compare between 2 different KPI or charts....

You can make it rolling 12 months or 6 months or if a year is selected it would give previous year sales or compare previous year by using Year = {$(=Max(Year)-1)} in the expression instead of Year = {$(=Max(Year))}

Would you care to upload the sample data?

Re: KPIs of Sales Dashboard for real estate company

justinvchiang — Tue, 12 Dec 2017 21:15:13 GMT

You could identify the top ranking Region, Sales Person, and Type of Apartments using sales or units sold:

='Top Apt. Type Sold: '& FirstSortedValue(ApartmentTypeDim, -Aggr(sum({<ApartmentTypeDim-= {'null()'}>} Sales),ApartmentTypeDim))

='Top Sales Person: '& FirstSortedValue(SalesPersonDim, -Aggr(sum({<SalesPersonDim-= {'null()'}>} Sales),SalesPersonDim))

='Top Region: '& FirstSortedValue(RegionDim, -Aggr(sum({<RegionDim-= {'null()'}>} Sales), RegionDim))