Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Heny
Contributor II
Contributor II

how to add totals line to bar chart

hi,

i have a bar chart with grouped items

i would like to add a line that shows the total of the values for each group 

is there a way to do this ?

thanks

4 Replies
vishsaggi
Champion III
Champion III

can you share some sample data to look into?
Heny
Contributor II
Contributor II
Author

here is a sample of my data:

DEPTRANSACTIONSDATE
a111301/15/2018
b109201/15/2018
c75501/15/2018
d55201/15/2018
a110901/16/2018
b125401/16/2018
c56301/16/2018
d48001/16/2018

 

and a screenshot of my chart. the line i want to show sums the total transactions (added in red):

sample.PNG

thanks!

vishsaggi
Champion III
Champion III

Add a combo chart with Dims as DATE, DEP
Exprs as :
=Sum(TRANSACTIONS)
=Sum(TOTAL <DATE> TRANSACTIONS) ----> This should be your line chart
In combo you will lose multicolored you can get those by writing an expr in Background color of your first expression when you click on + sign you can see background where you write your expr for color.
Heny
Contributor II
Contributor II
Author

Thanks for your reply, but a combo box is not a good option for me, as I need the dimensions to be grouped, that is I need to see a bar for each department on the graph, no matter how many drill downs I do (year, month, quarter, week, day)

I don't think a combo does this