Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Placing the Total Row within the Table.

In my straight table i see the option of having the Total Row in the Top or Bottom of the Chart, but is there a way to include it in the sorting so that I could quickly see which customers are above or below the average line?

i e

Cust A $4

Cust C $3

AVERAGE $2.50

Cust B $2

CustD $1

2 Replies
prieper
Honored Contributor II

Placing the Total Row within the Table.

Do not think that this is possible, but you may colour the customers above or below average.

Peter

Not applicable

Placing the Total Row within the Table.

Might it be possible to use a Sort on the amount? You do need Average to be a field within the table (a customer). Probably have to do that while loading the table.