topic Re: Need Idea's in QlikView

Need Idea's

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

Hi Community,

I got new project, please can you help me.....

I have financial data, i have to create a dashboard, they have given one set of data 100 locations with sales arranged by products.

and another set of data with sales results for the same locations which is organized by regional managers and their respective teams.

1. How to build when building the features of the dashboard and which charts suitable ??

Please give me some inputs..

Thanks in Advance....

Re: Need Idea's

Anil_Babu_Samineni — Sat, 27 May 2017 08:55:57 GMT

You mentioned you have data for financial. When i was with same domain i used these which i consolidated

1) Bar Chart

2) Gauge Chart

3) Scatter Chart

4) Line Chart

5) Tabular (Straight / Pivot)

Re: Need Idea's

prma7799 — Sat, 27 May 2017 08:59:05 GMT

You can build your finance application using Bar Chart , Gauge Chart , Straight / Pivot table , Combo Chart. ETC...

Re: Need Idea's

prma7799 — Sat, 27 May 2017 09:00:20 GMT

This Link help you to understand finance project with charts ...

QlikView

Re: Need Idea's

paulwalker — Sat, 27 May 2017 09:23:07 GMT

Thanks for reply folks....

i know those charts..

Please describe in detail some of the ways you would customize your dashboard with the end user (like Director level, CEO) in mind.

i have meeting with stakeholders, how to elaborate with them...

Suppose stakeholder will ask.. what you are provide for this application???

Like location wise.. how to present the best way...

Example: 1. We can achievable for 100 locations for data level security.

2. we can show top 10 and least 10 sales

3. best performance managers for location wise

I need some inputs best approaches....

Thanks...

Re: Need Idea's

Anil_Babu_Samineni — Sat, 27 May 2017 09:39:05 GMT

Good Question -

1) First of all we need to analyze more on data how data looks like (I mean Hierarchy)

2) When we talk about region sales i assume, Scatter chart is good to have

3) When we require to need country - Region - Sales (Could be Maps can help us like Latitude and Longitude)

4) Even though, We have good power and excellent performance with Qlik we can go Mekko chart to analyze more the plot orient of each region sales

5) Here, When performance comes to the picture we need to better understand and we can show like <=10 Country sales in that object to better analyze and good performance

6) When we talk about security, It's a;; about data hierarchy security. Let's take a example like if we have hierarchy called Manager - Super Manger - Employee

Here, We need to give security level for Designation / Operation level. Then if Manager login from Access point it should show all data. And when super manger login then we need to show only for Super Manager and Employee Sales. Finally, If we need to login as Employee is shouldn't go back because he don't have access to check insights of Manager and Super Manager.

Good luck for Case study and POC. Hope this helps

Re: Need Idea's

paulwalker — Sun, 28 May 2017 02:59:49 GMT

Excellent... Thank you

Do you have any example for Hierarchy level security,

Manager - Super Manger - Employee

Re: Need Idea's

Anil_Babu_Samineni — Sun, 28 May 2017 03:28:29 GMT

In Section Access, We have feature called OMIT. Let me play around suitable example for you. Is it okay for you?

Section Access;

Load * Inline [

ACCESS, USERID, PASSWORD, MANAGERIAL_HIERARCHY, OMIT

USER, UserName\Anil, Anil@123, MANAGER,

USER, UserName\Paul, Paul@123, Super Manager, MANAGER

USER, UserName\Walker, Walker@123, Employee, Super Manager

USER, UserName\Walker, Walker@123, Employee, MANAGER

];

Section Application;

May be helps

Re: Need Idea's

tajmohamed30 — Sun, 28 May 2017 10:09:10 GMT

Authorization using a Hierarchy