topic Re: Banking sector Dashboard in QlikView

Banking sector Dashboard

Fri, 17 Apr 2015 06:25:36 GMT

Hi Team,

I am buliding the Dashboard in Qlikview called "Banking sector".

Can you please give some Expression to built the dashboard.

Please find the attached file xls file for the source data.

I need to dispaly the following chart as follows.

1.Regional Wise Customer name

2.Rgional wise Customer Gender

3.Rgional wise Customer Annual income

4.Rgional wise Customer type.

Please give the experssion to try to build the dashboard.

I am awaiting for your responses.

Regards,

Karthik

Re: Banking sector Dashboard

morganaaron — Fri, 17 Apr 2015 07:44:04 GMT

Have you attempted any of it yet?

Unsure why people's names by region would give any benefit to a banking sector app? Aside from that, your annual income field isn't in a standard numeric format because of the ranges given, so you'll need to assign numeric values to those groupings if you want to analyse it in detail.

Some of those are very simple though - if you set a dimensions as region and gender and count your CustomerIDs for example. Maybe try something first and see where you get stuck?

Re: Banking sector Dashboard

Fri, 17 Apr 2015 08:37:37 GMT

Hi,

Not yet started.

Analyzing the list of KPI's to design the User interface part.

If possible can you share any KPI's to built the dashboard?

Regards,

Karthik

Re: Banking sector Dashboard

morganaaron — Fri, 17 Apr 2015 09:54:05 GMT

You're best asking the customer what they want to know from the data. If that's yourself, have a think about what you want to deliver - are you looking to see if there is disparity between regions about the average income? That would inform what you look to create.

Re: Banking sector Dashboard

vinod2086 — Fri, 17 Apr 2015 10:07:02 GMT

Hi Rajendran,

for this case u need to add fiscal calendar in your char after that u need to create charts(bar/line),

before creating charts confirm with users and try this =Count([Region]) and take dimension as region.