topic Re: Aggr question in QlikView

Aggr question

hossein_heydarniya — Sat, 16 Nov 2024 18:16:04 GMT

Hello,

I have a problem and cannot solve it, I was wondering one of you guys can help me here.

I have a table like this and I need to find out how much is total value of sales orders under and above $2000. (Aggregated by sales orders not Sales order_Line)

Sales_order	Line	Value
1935573	1	$ 489.44
1935573	2	$ 2,068.44
1935573	3	$ 633.60
2190057	1	$ 437.65
2242557	1	$ 560.56
2190057	2	$ 20,125.00
2238734	1	$ 13,989.97
2240007	1	$ 120.00
2240007	2	$ 400.00

I am using this expression for above $2000 but it doesn't work:

=Sum(Aggr(Sum({<Value= {">=2000"}>}Value),Sales_Order,Value))

Thank you,

Hossein

Re: Aggr question

sunny_talwar — Tue, 04 Aug 2020 16:21:52 GMT

This?

Sum({<Sales_Order = {"=Sum(Value) >= 2000"}>} Value)

Re: Aggr question

dplr-rn — Tue, 04 Aug 2020 16:34:09 GMT

add dimension like =if(aggr(sum(Value),Sales_order)>2000,Sales_order)

measure Sum(Value)

result

Re: Aggr question

hossein_heydarniya — Tue, 04 Aug 2020 17:30:05 GMT

Thank you sunny. It works perfectly.

I am really surprise actually the way this expression works.