Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

hsm12345
New Contributor

Sum data

Tax IDTotal
P110
P216
P120
P278
P298
P212
P225
P126
P185
P315
P423
P145
P365
P278
P425
P263
P414
P125

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.

2 Replies
Not applicable

Sum data

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

Not applicable

Sum data

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