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.

Not applicable

Sum based on criteria in another field

See attached data example.  I want to be able to create a table that shows four columns summarizing

ProducerNameGWP for BrokerageGWP for BindingTotal GWP

How do I construct my expressions to sum GWP in to 2 different columns based on the PRODUCT CLASSIFICATION field?

1 Solution

Accepted Solutions
MVP
MVP

Sum based on criteria in another field

For columns GWP for Brokerage use

=sum({<[Product Classification] = {'Brokerage'}>} GWP)

and similar for GWP for Binding column.

Hope this helps,

Stefan

1 Reply
MVP
MVP

Sum based on criteria in another field

For columns GWP for Brokerage use

=sum({<[Product Classification] = {'Brokerage'}>} GWP)

and similar for GWP for Binding column.

Hope this helps,

Stefan