Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
songzixian2016
Contributor III
Contributor III

How to add customized bar on top of stacked chart?

Hi all,

I have a time tracking dataset below indicating hours employee tracked per month:

   

MonthHourEmp
July1A
July2A
July3B
July4C
August2A
August8B
August4B
August1C

I made a stacked bar chart below:

I would like to add an additional bar on top of each bar to show untracked hours. In this case, all employees supposed to track 20 hours per month, so untracked hour for August is 5 and for July is 10.

Could anyone help me regarding how to add this bar?

Thanks,

Sherrie

1 Solution

Accepted Solutions
songzixian2016
Contributor III
Contributor III
Author

Inspired by Jean's answer, here is the answer to do it within same chart:

concatenate([TABLE1])

load

20-sum(Hour) as Untrackhours,

Month

Resident TABLE1

group by Month;

View solution in original post

4 Replies
sergio0592
Specialist III
Specialist III

Hi,

I manage to get this in the attached file.

P10.jpg

So create a second table with :

TABLE1:

LOAD * INLINE [

Month,    Hour,    Emp

July,    1,    A

July,    2,    A

July,    3,    B

July,    4,    C

August,    2,    A

August,    8,    B

August,    4,    B

August,    1,    C

];

TABLE2:

load

sum(Hour) as Totalhours,

20-sum(Hour) as Untrackhours,

Month

Resident TABLE1

group by Month;

Create a second graph with:

dimensions : Month, Valuelist('2','1')

expression : if(ValueList('2','1')='1',sum(Untrackhours),sum(Totalhours))

Overlap the two graphs with transparent head, legend,... for the second graph wich contains realized Hours (transparent) and untracked hours (yellow).

Regards

songzixian2016
Contributor III
Contributor III
Author

Hi Jean,

Thanks for your answer, it works. But is there anyway to create within same chart rather than two different charts? My concern is that when user drill through one chart the other chart (untracked) portion will stay the same and become distracting.

Thanks,

Sherrie

songzixian2016
Contributor III
Contributor III
Author

And if it is not within same chart, I could not add 'untracked hour' as a legend to the chart.

songzixian2016
Contributor III
Contributor III
Author

Inspired by Jean's answer, here is the answer to do it within same chart:

concatenate([TABLE1])

load

20-sum(Hour) as Untrackhours,

Month

Resident TABLE1

group by Month;

View solution in original post