Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
claudialet
New Contributor II

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

Re: How to exclude certain row from being calculated ?

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)

Re: How to exclude certain row from being calculated ?

Or this

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

Re: How to exclude certain row from being calculated ?

 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 ?

 

Highlighted

Re: How to exclude certain row from being calculated ?

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
New Contributor II

Re: How to exclude certain row from being calculated ?

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.




Re: How to exclude certain row from being calculated ?

What exactly is Level here?

claudialet
New Contributor II

Re: How to exclude certain row from being calculated ?

 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

Re: How to exclude certain row from being calculated ?

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

Community Browser