Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table aggregation question

Hi,

Probably a simple question.

The below excel example show what I want to do.

All CostComponentFrom has the same value. I only want this single value to be summed when I collapse the dimensions in the pivot table.

1 Solution

Accepted Solutions
its_anandrjs

Hi,

Might be it is your solution

See the attached sample file Hope this may be help you.

Let me know about this.

Rgds

Anand

View solution in original post

3 Replies
Not applicable

Here is the excel sheet showing what I am trying to do.

its_anandrjs

Hi,

You have to use Sum(Distinct Value) to show that value you are asking for like

132 + 78 = 210

And use pivot table to show this type of data representation.

Rgds

Anand

its_anandrjs

Hi,

Might be it is your solution

See the attached sample file Hope this may be help you.

Let me know about this.

Rgds

Anand

View solution in original post