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

shrusrkt — Thu, 26 Oct 2017 05:37:34 GMT

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.

Please help.

Thanks in advance.

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

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

sahadevpatil‌