Only show one row per product

Simon4 — Fri, 04 Nov 2022 09:42:04 GMT

Dear all,

I am making a saleslist. Right now I am trying to add the amount of a product that is in production and the finishing date. when I do this a extra row pops up. How do I avoid this?

Result without production info

Result with production info

I am using these formula's

this one for the quantity in production

=if(isnull(DATEPRODUCTIONFINISHED), ORIGINALSUBASSEMBLYQUANTITY)

this one for the production date

=if(isnull(DATEPRODUCTIONFINISHED),PLANNEDPRODUCTIONENDDATE)

How do I avoid the double lines per product?

Thankyou in advance for the help.

Re: Only show one row per product

Simon4 — Fri, 04 Nov 2022 09:44:07 GMT

to add:

When DATEPRODUCTIONFINISHED is not null, the production amount transfered to the stock because the product is finished, so it is no longer in production.

topic Re: Only show one row per product in QlikView

Only show one row per product

Re: Only show one row per product