Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Total below each period. bar chart

Hello,

¿is there any way to show the total of each period below of each period?

thank you

Capture.PNG

11 Replies
tresesco
MVP
MVP

If you have latest qv version, you might be able to see :

Capture.JPG

in presentation tab of the chart properties. Enable 'Stll Show Total on Top'.

YoussefBelloum
Champion
Champion

Hi Pablo,

Find attached a solution for your problem.

Regards

Youseef

Anonymous
Not applicable
Author

i am sorry i mean below each period i want the total of the period

vinieme12
Champion III
Champion III

replace Date dimension with a calculated Dimension

=AGGR(Date & chr(10) &sum(Sales) , Date)


you can also add Num() formatting


=AGGR(Date & chr(10) &NUM(sum(Sales),'#,###') , Date)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Hello,

i don´t see the total by date.

i attach the file with the dimension calculated.

krishnacbe
Partner - Specialist III
Partner - Specialist III

Please find the attached file. Hope it helps

Your calculated dimension should be below

=AGGR(Date & chr(10) &num(sum(Sales),'#.##0') , Date)

Anonymous
Not applicable
Author

i don´t see the totals

Capture.PNG

krishnacbe
Partner - Specialist III
Partner - Specialist III

the Code is not working in your copy? I am able to view in which I have attached.

Capture.PNG

antoniotiman
Master III
Master III

What about this ?