topic Re: How to count number of ref purchased between 2 dates in QlikView

How to count number of ref purchased between 2 dates

chriscools — Tue, 23 May 2017 21:22:00 GMT

Hello,

i have an expression to give the amount in purchasing for purchaseorders placed between 2 certain dates:

=Sum({1<SupplierOrderDate={">=$(=minDatumHuidigAankoopseizoen)<=$(=maxDatumHuidigAankoopseizoen)"}>}(SupplierOrderPriceNetDefaultCurrency * SupplierOrderQtyOrdered))

How should i make the expression to count how article numbers are involved?

i tried this:

=count ( distinct {1<SupplierOrderDate={">=$(=minDatumHuidigAankoopseizoen)<=$(=maxDatumHuidigAankoopseizoen)"}>}SkuCode)

but this does not seem to work...

any ideas ?

thanx

Chris

Re: How to count number of ref purchased between 2 dates

Peter_Cammaert — Tue, 23 May 2017 21:29:29 GMT

¨Pretty difficult to diagnose with just a couple of expressions that look OK. Would it be possible for you to post an example document with which you are having this same problem?

Re: How to count number of ref purchased between 2 dates

chriscools — Tue, 23 May 2017 22:34:55 GMT

Hey Peter,

i made an example document.

in the table on the right with the orange header i have a count for the SkuCode, but it gives me 70 SkuCodes and in the table on the left side it clearly are not so much articles.

For example "Cutlery" on the left has 1 SkuCode , but on the right 5...