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: 
chipmunkG
Contributor
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
Master
Master

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

View solution in original post

8 Replies
SharathPanackal
Partner - Contributor III
Partner - Contributor III

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
Master
Master

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

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.

SharathPanackal
Partner - Contributor III
Partner - Contributor III

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
Contributor
Contributor
Author

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

shiveshsingh
Master
Master

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

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

Woman LOL Woman LOL

shiveshsingh
Master
Master

Perfect, please close the thread 🙂