# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
New Contributor

## how to calculate total with exculde some row

Hi,

Kindly help me how to calculate  total of score with exclude the yellow color.

Labels (3)

• ### sum

1 Solution

Accepted Solutions
Honored Contributor

## Re: how to calculate total with exculde some row

Hi Try like this If(New_Speed <>'Others' and New_Speed <> '10Mbps' ,New_Speed)
8 Replies
Partner

## Re: how to calculate total with exculde some row

Hi ChipmunkG,

Is there any criteria to arrive at the higlighted rows? if you can share that logic it might help in bringing up a solution.

Regards,
Sharath Panackal
Honored Contributor

## Re: how to calculate total with exculde some row

Hi May be you can exclude these figures in dimensions itself..like If(Speed<>'Others',Speed) as Speed
New Contributor

## Re: how to calculate total with exculde some row

when i'm try this one "If(New_Speed <>'Others',New_Speed) ", the exactly result i want.

but when i'm try " If(New_Speed <>'Others',New_Speed, If(New_Speed <>'10Mbps',New_Speed ", the code is not working.

Partner

## Re: how to calculate total with exculde some row

Hi ChipmunkG,

Hope it is just a syntax issue since i see you haven't closed the second paranthesis.
Please try If(New_Speed <>'Others',New_Speed, If(New_Speed <>'10Mbps',New_Speed))

Regards,
Sharath Panackal
New Contributor

## Re: how to calculate total with exculde some row

ops! my typo. actually in my code has the one. but still not working.

Honored Contributor

## Re: how to calculate total with exculde some row

Hi Try like this If(New_Speed <>'Others' and New_Speed <> '10Mbps' ,New_Speed)
New Contributor

## Re: how to calculate total with exculde some row

yessss. that is great!!!!!! thank you so much sir!

Honored Contributor