Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Rangesum in Pivot

Hi Qlik Community,

I have attached an image which shows the problem and required result Excel. The measure is the count of contribution which is calculated as count(contribution). I have 2 questions:

1. I need to present it in the form of a pivot as shown in the image with the heading "Query".

2. Once the first problem is solved, I need to show row-wise sum as shown in the image with the heading "Required Result".

Please note that values highlighted in yellow are to be excluded.

I would really appreciate the help. Thanks

 Kashif

Labels (3)
0 Replies