Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
shrusrkt
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.