Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil_sawargave
Contributor III
Contributor III

Sum of different value of one column with codition

Hello all,

i am new on Qlik sense, 

sunil_sawargave_2-1664781117837.png

Here I want to Sum SCRAP COST value column with "Same Date", "Same Shop NAME", "Same REASON CODE"

pls revert me.

 

Thanks 

Sunil

 

 

 

Labels (2)
12 Replies
sunil_sawargave
Contributor III
Contributor III
Author

Thnak  you Mayil Vahanan R for your valuable feedback,

Its working but calculation something may be wrong .

sunil_sawargave_0-1664864166504.png

In Above D1 Block  Sum of Scrap cost75178.7  but it display 37589.35.

 

Thanks &n regards

Sunil Sawargave

 

sunil_sawargave
Contributor III
Contributor III
Author

Thanks For your valuable reply MayilVahanan,

Its Working Fine , Thank you very much.

 

Sum(Total<[SHOP NAME],  [REASON CODE] >  [SCRAP COST])

 

Thanks & regards

Sunil

MayilVahanan

HI

Pls close this thread if you get the expected results

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.