Banking sector Dashboard

[#1]

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

[morganaaron]

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?

[#3]

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

[morganaaron]

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.

[vinod2086]

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.