Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

chipmunkG
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.

Capture3.PNG

Labels (3)
1 Solution

Accepted Solutions
shiveshsingh
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
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
shiveshsingh
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
chipmunkG
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
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
chipmunkG
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.

shiveshsingh
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)
chipmunkG
New Contributor

Re: how to calculate total with exculde some row

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

Woman LOL Woman LOL

shiveshsingh
Honored Contributor

Re: how to calculate total with exculde some row

Perfect, please close the thread 🙂