Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Sum of bar values (bar chart)

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

let me know

Not applicable

Re: Sum of bar values (bar chart)

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?

Re: Sum of bar values (bar chart)

Could you share your qvw?

ankit777
Valued Contributor

Re: Sum of bar values (bar chart)

Hi,

in dimension limits, check show total

Re: Sum of bar values (bar chart)

please share your app

Not applicable

Re: Sum of bar values (bar chart)

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
Honored Contributor II

Re: Sum of bar values (bar chart)

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

Community Browser