Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
LP27
Creator II
Creator II

Sum N/A in a row in Qlik Senes

Hi Everyone,

 

I have scenario as below

Table 1-

Defect_NameDefect Value
Compound100
N/A(Process)200
Scrap400
N/A(Sample)500

 

So now I need to only sum the Defect value starting with Defect name N/A.

example-

N/A = 700

could someone guide me.

 

Thanks in advance.

 

Regards,

LP27

Labels (3)
3 Replies
tresesco
MVP
MVP

Try using set analysis like:

Sum({<Defect_Name={"N/A*"}>} [Defect Value])

LP27
Creator II
Creator II
Author

Thanks! It worked well

LP27
Creator II
Creator II
Author

Apologies!

For Few records the sum figure is right and for few records its wrong. is there any other way to group all N/A together ?