Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
APHardeau
Contributor II
Contributor II

Summation of measures in column based on one dimension being equal or not equal to another one

As mentioned in the title, I am trying to get a summation of all the values in a column, based on one dimension being equal to another.

OwnerDeliverer.png

 

 

 

 

What I have done is create a measure 'Owning Value', where the material revenue is summed if the Deliverer is equal to the Owner, and a measure 'Delivering Value' where the material revenue is summed is the Owner and Deliverer do not match. This was done with P() as follows:

Sum({<[Invoice Number]=P({<[Owner]=[Deliverer]>})>}[Material Revenue])

Sum({<[Invoice Number]=P({<[Owner]-=[Deliverer]>})>}[Material Revenue])

While this works, it only works when I make a selection for the Deliverer. When this is done, I only get the results for one deliverer, when I would prefer to be able to see all of them (c. 65 unique ones).

Without a selection:

OwnerDelivererNoSelect.png

 

 

 

 

 

 

With a Deliverer selection:

OwnerDelivererSelect.png

 

 

 

 

Have I jut used the P() code incorrectly? Is there a way to achieve what I am trying?

Labels (3)
0 Replies