Is this possible with p()?

john_oll — Mon, 10 Sep 2018 15:09:46 GMT

Product:

LOAD * INLINE [

Product, FinishedProduct

111, 411

411, 411

112, 412

412, 412

];

ProductSales:

LOAD * INLINE [

Product, Customer, Sales

411, Miller, 20

411, Miller, 30

412, Smith, 100

];

With this data, I would like to accomplish the following result (without using applymap etc. in the script):

I think this should be possible with p() or standard set analysis.

My best guess is
sum( {< Product = P( FinishedProduct) >} Sales)

but this did not work.
Is this possible with p()?

Re: Is this possible with p()?

marcus_sommer — Tue, 11 Sep 2018 11:23:58 GMT

No, this isn't possible with p() or e() because they are related to the (not) possible values from a global point of view and not on a dimension-level.

Beside this I'm not sure that your association of the tables per Product is suitable or if it shouldn't be better on FisnishedProduct? Is there any tag available to differ between Product and RawProduct?

- Marcus

topic Is this possible with p()? in QlikView

Is this possible with p()?

Re: Is this possible with p()?