topic Re: SUM formula in a chart (Measures) in QlikView

SUM formula in a chart (Measures)

tigra999 — Wed, 25 Nov 2020 16:16:04 GMT

Hello, I hope I can get some help...

I have a measure in a chart (not script/coding) I want to calculate the sum of qty ordered units but cannot get the formula correct..

Using "sum(qty_ordered)" takes the full right column below to a sum of 13 but I only want it to calculate the sum of the item_type = 1.

Below I have an example of one (1) order which consist of several orderlines but its only the main product (in this case product "e" which shall be calculated as qty ordered).

Is there a formula to make this happen so the data only calculates the main product even though the full order consist of several other equipment (in a Measures chart)? I have tried IF and other formulas without a success..

Best regards

peter

Product/equipment	Price	Item type	Qty ordered	order line no
a	50	3	1	1
b	110	3	1	2
c	250	2	1	3
d	25	2	1	4
e	2500	1	1	5
f	10	3	1	6
g	75	3	1	7
h	375	2	1	8
i	500	3	1	9
j	40	3	1	10
k	1	3	1	11
l	100	4	1	12
m	30	5	1	13

Re: SUM formula in a chart (Measures)

aarkay29 — Thu, 16 Feb 2017 17:00:14 GMT

sum({<[Item type]={'1'}>}Qtyordered)

Re: SUM formula in a chart (Measures)

Colin-Albert — Thu, 16 Feb 2017 17:27:41 GMT

You can do this using Set Analysis

sum({<item_type ={1}>} qty_ordered)

Re: SUM formula in a chart (Measures)

albertovarela — Thu, 16 Feb 2017 17:44:58 GMT

Check out these 2 videos with Set analysis basics...

https://community.qlik.com/docs/DOC-8039

https://community.qlik.com/docs/DOC-8174

Re: SUM formula in a chart (Measures)

tigra999 — Thu, 16 Feb 2017 18:17:24 GMT

Great help Gents!!! working fine. 🙂

Re: SUM formula in a chart (Measures)

avinashelite — Thu, 16 Feb 2017 18:44:58 GMT

Try this

sum({<[Item type]={1}>}Qtyordered)

check this documents too