Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum of bar values (bar chart)

Hello all,

I have a chart and I want to display (whether in the same chart or in another object) the sum of all the bar values.

Thank you

7 Replies
alexandros17
Partner - Champion III
Partner - Champion III

In Another Chart simply delete the dimension and use only the expression

let me know

Not applicable
Author

But I have in my expression a condition depending on the dimension. Is it possible to use aggregate with a similar expression as in the bar chart? If yes then how to do so?

alexandros17
Partner - Champion III
Partner - Champion III

Could you share your qvw?

ankit777
Specialist
Specialist

Hi,

in dimension limits, check show total

avinashelite

please share your app

Not applicable
Author

I have a personnal edition,but here is my expression:

Sum(if(X+Y<=([time]/var1,Y,0)) 

where [time] is a field and var1 a variable (having a constant value)

[time] has 3 values: 60, 3600 and 86400

depending on the value of [time] one of the 3 dimensions [minute],[hour] or [day] is activated.

buzzy996
Master II
Master II

try tis,from dimension limits tab,check the check box "show total"1