Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Calculating the sum of the column values in a straight table

I have to calculate the sum of the displayed column value in a straight chart. How should i proceed.

In my application i have displayed the counts for a particular date range in a straight chart. Now i have to show the sum of the count displayed in the chart. How should i do that.

Thanks

Vikas

2 Replies
Not applicable

Calculating the sum of the column values in a straight table

Hi Vikas,

If you have hard-coded your expression (columns), then you can do a sum over them by calling their label names. Otherwise, if you used a dynamic label, you can use the column function, e.g. column(1) + column(2) + ..., where column(N) is the Nth expression stated from top to bottom in the expression tab.

If this doesn't answer your question, do you have a sample QVW to see what you're trying to do?

Not applicable

Calculating the sum of the column values in a straight table

On the expression tab of the properties menu there is something that says "total mode" and you want "sum of rows".

Community Browser