Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.