Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Stacked bar graph is killing me

Im trying to make a stacked bar graph. The left y dimenstions should be a percentage breakdown by tens, 0,10,20,30...100. each bar represent another employee name. the bars upward (no under x-axis extending bars) bars are divided into two parts, the bottom should be the red percentage of negative scored performance and the top should be the positive green percentage of positivly scored performance ratings.

Meaning

total bar height=100% for each one

Red part of bar= sum(fabs(negative score))/total score

Green part of bar= sum(positive score)/total score

sample data:

Employee 1  ,project 1, -45

Employee 1 , project 2, 84

Employee 1 , project 2, 8

Employee 1 , project 2, 24 <-project can have multiple rating

Employee 2  ,project 3, -95

Employee 2 , project 4, -99 <-employee2 will be an all red bard with a height of

Employee 2  ,project 5, -45

Employee 3 , project 2, 84

Employee 3 , project 7, 4

Employee 3 , project 7, -89

Employee 3 , project 7, 50

Please help, ive spend a week on this and i got no where

Assume Im a begginer and need as detailed help as possible. Please

see the attached pic. Picture is not based on numbers above

Screen Shot 2012-08-01 at 3.10.00 AM.png

1 Solution

Accepted Solutions
Lee_Matthews
Former Employee
Former Employee

Aha, thanks for the data.

I modified the solution a little to show each bar as 100%.

View solution in original post

6 Replies
Lee_Matthews
Former Employee
Former Employee

Can you load some data into a QVW and post it?

Not applicable
Author

Would copying and pasting a bunch of columns suffice. Im not sure how to add only a few columns of qvw that access a database. Sorry Im really a begginer and im trying to pick all this

(KEY)Project Name  |   Score |  Employee

Project 1             45          emp1

Project 1             5          emp1

Project 1             26          emp1

Project 1             6          emp2

Project 2             null/0          emp1

Project 2             null/0          emp3

Project 3             45          emp1

Project 3             -60          Null

Project 4            45          emp1

Project 5             -99          emp5

Project 5             -60          emp5

Project 5             25         emp10

Project 6             null/0          emp10

Project 5             45          emp1

Project 6             56          emp12

Project 7             -60          emp90

Its basically any permutation of the fields. Im sorry I couldnt give you the QVW file, if you rahter have that, can you explain to me how to do it if the source is from a local database and I cant give out the password/username

rathodniky
Creator
Creator

Hi,

I have attached a Qlikview file.

     Where I have added a field in the load script if(Score>0,1,0) as Flag

     And expression : Sum(Score*(If(Flag,1,-1))) on a Stacked bar chart.

Hope it helps...

Lee_Matthews
Former Employee
Former Employee

Go into the script, and select Insert > Load Statement > Load Inline

Then you can just key the data in to make a load script.

Lee_Matthews
Former Employee
Former Employee

Aha, thanks for the data.

I modified the solution a little to show each bar as 100%.

Not applicable
Author

THNAK YOU