Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products.
All content is subject to change and is provided without warranty.
๊ธฐ๋ณธ ์ฝ˜ํ…์ธ ๋กœ ๊ฑด๋„ˆ๋›ฐ๊ธฐ ๋ณด์™„์ ์ธ ์ฝ˜ํ…์ธ ๋กœ ๊ฑด๋„ˆ๋›ฐ๊ธฐ

Sum - ์ฐจํŠธ ํ•จ์ˆ˜

Sum() ์€ ์ง‘๊ณ„ ๋ฐ์ดํ„ฐ ์ „์ฒด์—์„œ ํ•„๋“œ ๋˜๋Š” ํ‘œํ˜„์‹์„ ํ†ตํ•ด ์ง€์ •๋œ ๊ฐ’์˜ ํ•ฉ๊ณ„๋ฅผ ๊ณ„์‚ฐํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ:  

Sum([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr])

๋ฐ˜ํ™˜ ๋ฐ์ดํ„ฐ ์œ ํ˜•: ์ˆซ์ž

์ธ์ˆ˜
์ธ์ˆ˜์„ค๋ช…
expr์ธก์ •ํ•  ๋ฐ์ดํ„ฐ๊ฐ€ ํฌํ•จ๋œ ํ‘œํ˜„์‹ ๋˜๋Š” ํ•„๋“œ์ž…๋‹ˆ๋‹ค.
SetExpression๊ธฐ๋ณธ์ ์œผ๋กœ ์ง‘๊ณ„ ํ•จ์ˆ˜๋Š” ์„ ํƒ์— ์˜ํ•ด ์ •์˜๋œ ์‚ฌ์šฉ ๊ฐ€๋Šฅํ•œ ๋ ˆ์ฝ”๋“œ์˜ ์ง‘ํ•ฉ์„ ์ง‘๊ณ„ํ•ฉ๋‹ˆ๋‹ค. ์ง‘ํ•ฉ ๋ถ„์„ ํ‘œํ˜„์‹์œผ๋กœ ๋Œ€์ฒด ๋ ˆ์ฝ”๋“œ ์ง‘ํ•ฉ์„ ์ •์˜ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.
DISTINCTํ•จ์ˆ˜ ์ธ์ˆ˜ ์•ž์— DISTINCT๋ผ๋Š” ๋‹จ์–ด๊ฐ€ ์žˆ์„ ๊ฒฝ์šฐ ํ•ด๋‹น ํ•จ์ˆ˜ ์ธ์ˆ˜์˜ ํ‰๊ฐ€ ๊ฒฐ๊ณผ๋กœ ์ƒ์„ฑ๋œ ์ค‘๋ณต์ด ๋ฌด์‹œ๋ฉ๋‹ˆ๋‹ค.
์ •๋ณด ๋ฉ”๋ชจDISTINCT ํ•œ์ •์ž๊ฐ€ ์ง€์›๋˜๊ธฐ๋Š” ํ•˜์ง€๋งŒ, ์ผ๋ถ€ ๋ฐ์ดํ„ฐ๊ฐ€ ๋ˆ„๋ฝ๋˜์—ˆ์Œ์—๋„ ์ „์ฒด ๊ฐ’์ด ํ‘œ์‹œ๋˜๋Š” ๊ฒƒ์œผ๋กœ ์˜คํ•ด๋ฅผ ์ผ์œผํ‚ฌ ์ˆ˜ ์žˆ์œผ๋ฏ€๋กœ ๊ฐ๋ณ„ํ•œ ์ฃผ์˜ ํ•˜์— ์‚ฌ์šฉํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค.
TOTALTOTAL์ด ํ•จ์ˆ˜ ์ธ์ˆ˜ ์•ž์— ์˜ค๋Š” ๊ฒฝ์šฐ, ํ˜„์žฌ ์„ ํƒ์„ ๊ณ ๋ คํ•˜๋˜ ํ˜„์žฌ ์ฐจ์› ๊ฐ’์— ๊ด€๋ จ๋˜์ง€ ์•Š์€ ๊ฐ€๋Šฅํ•œ ๋ชจ๋“  ๊ฐ’์— ๋Œ€ํ•œ ๊ณ„์‚ฐ์ด ์‹คํ–‰๋ฉ๋‹ˆ๋‹ค. ์ฆ‰, ์ฐจํŠธ ์ฐจ์›์€ ๋ฌด์‹œ๋ฉ๋‹ˆ๋‹ค.

TOTAL [<fld {.fld}>](์—ฌ๊ธฐ์„œ TOTAL ํ•œ์ •์ž ๋’ค์—๋Š” ํ•˜๋‚˜ ์ด์ƒ์˜ ํ•„๋“œ ์ด๋ฆ„ ๋ชฉ๋ก์ด ์ฐจํŠธ ์ฐจ์› ๋ณ€์ˆ˜์˜ ํ•˜์œ„ ์ง‘ํ•ฉ์œผ๋กœ ์˜ด)์„ ์‚ฌ์šฉํ•˜์—ฌ ๊ฐ€๋Šฅํ•œ ์ „์ฒด ๊ฐ’์˜ ํ•˜์œ„ ์ง‘ํ•ฉ์„ ๋งŒ๋“ญ๋‹ˆ๋‹ค.

์ง‘๊ณ„ ๋ฒ”์œ„ ์ •์˜

์˜ˆ: ์ฐจํŠธ ํ‘œํ˜„์‹
์˜ˆ๊ฒฐ๊ณผ
Sum(UnitSales)UnitSales์— ์žˆ๋Š” ๊ฐ’์˜ ํ•ฉ๊ณ„๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.
Sum(UnitSales*UnitPrice)UnitPrice์— ์ง‘๊ณ„๋œ UnitSales๋ฅผ ๊ณฑํ•œ ํ•ฉ๊ณ„๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

Sum(TOTAL UnitSales*UnitPrice)TOTAL ํ•œ์ •์ž๋Š” ์ฐจํŠธ ์ฐจ์›์„ ๋ฌด์‹œํ•˜๊ณ  ํ•ฉ๊ณ„๊ฐ€ ๊ณ„์‚ฐ๋จ์„ ์˜๋ฏธํ•˜๋ฏ€๋กœ, ํ…Œ์ด๋ธ”์˜ ๋ชจ๋“  ํ–‰์— ๋Œ€ํ•œ ์ด ํ•ฉ๊ณ„์™€ ์ดํ•ฉ์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.
Sum({1} TOTAL UnitSales*UnitPrice) ์ง‘ํ•ฉ ๋ถ„์„ ํ‘œํ˜„์‹ {1}์€ ์„ ํƒํ•œ ๋‚ด์šฉ๊ณผ ๊ด€๊ณ„์—†์ด ํ‰๊ฐ€ํ•  ๋ ˆ์ฝ”๋“œ ์ง‘ํ•ฉ์„ ALL๋กœ ์ •์˜ํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ - Sum ๊ธฐ๋ณธ ์‚ฌํ•ญ

์˜ˆ - Sum ์‹œ๋‚˜๋ฆฌ์˜ค(ํŒ๋งค ๋ฐ์ดํ„ฐ ์ง‘๊ณ„)

์ด ํŽ˜์ด์ง€๊ฐ€ ๋„์›€์ด ๋˜์—ˆ์Šต๋‹ˆ๊นŒ?

์ด ํŽ˜์ด์ง€ ๋˜๋Š” ํ•ด๋‹น ์ฝ˜ํ…์ธ ์—์„œ ์˜คํƒ€, ๋ˆ„๋ฝ๋œ ๋‹จ๊ณ„ ๋˜๋Š” ๊ธฐ์ˆ ์  ์˜ค๋ฅ˜์™€ ๊ฐ™์€ ๋ฌธ์ œ๋ฅผ ๋ฐœ๊ฒฌํ•˜๋ฉด ๊ฐœ์„  ๋ฐฉ๋ฒ•์„ ์•Œ๋ ค ์ฃผ์‹ญ์‹œ์˜ค!