Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Help with Pivot table?

Hi Everyone,

I have a pivot table and i m not getting expected results when i  use Total function. Can anyone please help me to understand where i went wrong?

Please find attached document which explains my problem with example.

1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

use Sum(Net)/Sum(Total <Group> Net) for your % column.

View solution in original post

2 Replies
neelamsaroha157
Specialist II
Specialist II

use Sum(Net)/Sum(Total <Group> Net) for your % column.

View solution in original post

ali_hijazi
Partner
Partner

the sum total net should take into consideration the Group dimension

so your expression should be sum(Net)/Sum(Total<Group>Net)community.PNG

I can walk on water when it freezes