Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
claudialet
Contributor III
Contributor III

How to exclude certain row from being calculated ?

 Here is attached data and view of table 

 

Entire table is being calculated by : sum(amounts * rate)

However do I make a certain row not be affected this expression and just display value as is ? 

Entire table is calculated. One row should just show the amount as is.

 

8 Replies
sunny_talwar

So, in your example, you want Orange to always show the same number regardless of the selection, but everything else should change? May be this

Sum({<[Line Des] += {'Orange'}>}Amount * Rate)
sunny_talwar

Or this

Sum({$+1<[Line Des] = {'Orange'}>}Amount)
claudialet
Contributor III
Contributor III
Author

 Sorry that is not it. 

 

 I have a complicated  roll up by level filter requirement.  It should be 

 

Filter Level 1 :   sum ( Amount * Rate) for the whole table except row 'Orange'  ( display as is) 

Filter Level 2 : sum ( Amount * Rate)  for (Dim1 + Dim 2) but because of auto sum function at level 2 row 'Orange' adds no matter what. 

 

Any ideas ?

 

sunny_talwar

I am not sure I follow... would you be able to provide the expected output based on the sample data you have in the image?
claudialet
Contributor III
Contributor III
Author

Here is my expression. It seems ok at Level 1 but Level 2 is not right. It auto sums row ‘Orange’
And data at level2 does not flow in correctly.

sum(distinct(ValueAmount) * if($(vFilter)= ' Level1', Percent,1) *if($(vFilter)= ' Level2', FXRate,1))



At Level 1 : Show sum (amount * Percent)
At Level2 : Show sum ( amount * Percent * FXRate)

But at both levels row ‘Orange’ should be just display ( Amount) as is calculation has no effect.




sunny_talwar

What exactly is Level here?

claudialet
Contributor III
Contributor III
Author

 It 's a group filter extension  and levels are assigned by variables. Vfilter =1 and so on

 

 So Level1 - has a entity dimension and level2 has another dimension that rolls up into Level 1

sunny_talwar

All I see is this

image.png

And I see reference of entity or any other dimension. I am not sure I can follow your requirement. Unless you are able to provide a sample where we can see all of this, I am not sure how to help you.

Best,
Sunny