Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor III

Qlikview query to find addition of field values in pivot table.

Hi everyone,

henri-lo

sahadevpatil

brijeshfofadiya

City, Agent Name, GC Code, Product, Business_Type are in Dimension.

In product--> Motor, Health, SME are the field-values.

In Business_Type --> New, Renewal field-values are there.

I want to add new for all products  also I want to add renewal for all products.

I had tried do it in pivot table--> presentation tab --> partial sum, however I got the total for Products,  I dint get total_New for Products, & total Renewal for Products.

Please refer the attachment below.

IMG20171025123330.jpg

Please help.

Thanks in advance.