topic Sum data in QlikView

Sum data

Anonymous — Fri, 10 Jun 2011 21:19:07 GMT

I have 4 Tax IDs and Total. I like to sum all the P1 to get a P1_Total, sum all the P2 to get a P2_Total and the same for P3 and P4.

How can I do this

Thanks.

Fri, 10 Jun 2011 21:46:42 GMT

create a pivot or straight table chart, add Tax ID as the dimension & sum(Total) as your expression.

Mon, 13 Jun 2011 07:51:18 GMT

I think TOTAL might be a reserved word, maybe better pick a different name for your field.