topic Re: Orders with possible item in QlikView

Orders with possible item

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

Hi all,

I am trying to get list all products and order value when a particular item exits in that order

Ex:

Result: show only order contains item.no=24 and order totals

I am using below expression to get totals

Sum({<[Item.no]={'24'}>}Aggr(Sum(TOTAL <[ Order.no]> {<[ Order.no = P({<[Item.no]={'24' }>}[ Order.no]),[Item.no]>}[Amount]),[ Order.no], [Item.no]))

I want to get the all the items in orders. Is that possible??

sunny_talwar — Fri, 04 Aug 2017 13:00:12 GMT

All items in orders? Not sure I understand? Can you elaborate?

effinty2112 — Fri, 04 Aug 2017 13:01:05 GMT

Hi Madhu,

Does this give you what you need?

Order.no	sum({$<Order.no = P({<Item.no = {24}>})>}Amount)
1	18
3	33

Regards

Andrew

sunny_talwar — Fri, 04 Aug 2017 13:02:23 GMT

May be this

Sum(TOTAL <[Order.no]> {<[Order.no] = P({<[Item.no]={'24' }>}[Order.no]),[Item.no]>}[Amount])

Kushal_Chawda — Fri, 04 Aug 2017 13:12:11 GMT

abhi me ye expression dalne hi wala tha.. but tera dekh k rook gaya

effinty2112 — Fri, 04 Aug 2017 13:20:19 GMT

Hi Madhu,

A pivot table maybe gives a nice presentation.

madhuqliklondon — Fri, 04 Aug 2017 13:41:36 GMT

Thank you Andrew.

madhuqliklondon — Fri, 04 Aug 2017 13:42:22 GMT

Thanks bhai.