topic Re: How to get first 4 Weeks Sold Quantity? in QlikView

How to get first 4 Weeks Sold Quantity?

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

Hi All,

//Article 1st Launch Date (based 1'st sold date)

=min(TOTAL <ArticleNo,Countries> {<Type={'Sales'},Year=,Week=,StoreName=>} Date)

how to get the 1st 4 Weeks sold qunatity using sold date in qlikview set analysis?

I've tried like below and it's gave all 0,

=sum({<Date={">=[Launch Date]<=[Launch Date]+28"},StoreName=>} SoldQty)

looking for you valuable suggestion. tks

Thanks, Dev

Re: How to get first 4 Weeks Sold Quantity?

tresB — Tue, 06 Dec 2016 05:16:49 GMT

Try like:

=sum({<[Launch Date]={">=$(=Date(Min([Launch Date])))<=$(=Date(Min([Launch Date])+28))"},StoreName=>} SoldQty)

Re: How to get first 4 Weeks Sold Quantity?

Anil_Babu_Samineni — Tue, 06 Dec 2016 05:28:26 GMT

Do you have Week Field with you

Or Else You may Create This

Week([Launch Date]) as Week

And then Seta anlysis seems this

=sum({<Week= {"'>=' & $(=Week(YearStart([Launch Date]))) & '<' & $(=Week(MonthEnd(YearStart([Launch Date]))))"}>} SoldQty)

Re: How to get first 4 Weeks Sold Quantity?

devarasu07 — Tue, 06 Dec 2016 05:42:15 GMT

HI,

Thanks for you input, i've tried and still it's not working. please find the sample attachment. tks

Regards,Dev

Re: How to get first 4 Weeks Sold Quantity?

devarasu07 — Tue, 06 Dec 2016 05:45:23 GMT

Hi Anil,

Thanks for you reply, tried your method and still getting 0. any other suggestion? tks

Re: How to get first 4 Weeks Sold Quantity?

tresB — Tue, 06 Dec 2016 05:50:05 GMT

You don't have a date like [Launch Date]. Try with Date field itself like:

=sum({<Date={">=$(=Date(Min([Date])))<=$(=Date(Min([Date])+28))"}>} SoldQty)

Re: How to get first 4 Weeks Sold Quantity?

devarasu07 — Wed, 07 Dec 2016 16:58:30 GMT

stalwar1‌,Tresesco B

PFA, if we select any week from week filter then "4 Weeks Sold Qunatity" giving 0. please advise me.

1st Sales Date by article (

=min(TOTAL <ArticleNo> Date)

4th Week Sales Date by article

=min(TOTAL <ArticleNo> Date)+28

1st 4 week sold Quantity

=sum({<Date={">=$(=Date(Min([Date])))<=$(=Date(Min([Date])+28))"}>} [Sold Qty])

Thanks Dev

Re: How to get first 4 Weeks Sold Quantity?

sunny_talwar — Wed, 07 Dec 2016 17:16:38 GMT

I can't find the expression you are talking about in your attached qvw file. Am I missing something here?

Re: How to get first 4 Weeks Sold Quantity?

devarasu07 — Wed, 07 Dec 2016 17:24:56 GMT

Hi stalwar1‌

In that qlikview document please refer below column fxn

4 Wks ROS(Method1)

=sum({<Date={">=$(=Date(Min([Launch Date])))<=$(=Date(Min([Launch Date])+28))"}>} SoldQty)

Re: How to get first 4 Weeks Sold Quantity?

devarasu07 — Wed, 07 Dec 2016 17:51:42 GMT

Hi stalwar1‌

if do week selection then 4 week sold quantity not giving correct result.

1st 4 Week Sold Quantity (below expression working i don't have week filter selection, but my requirement want to have dynamic week filter)

=sum({<Date={">=$(=Date(Min([Date])))<=$(=Date(Min([Date])+28))"},Type={'Sales'}>} SoldQty)

Re: How to get first 4 Weeks Sold Quantity?

sunny_talwar — Wed, 07 Dec 2016 17:54:23 GMT

I think you will have to give some more information. For instance it would be helpful if you can tell us based on certain selection what you are seeing and what you expect to see.

Re: How to get first 4 Weeks Sold Quantity?

devarasu07 — Wed, 07 Dec 2016 18:13:33 GMT

Hi stalwar1‌,

Please refer the sample article,

if user selected filter (Year as 2015 and week as 15) then they wanted to see that article first 4 weeks sold quantity

below example,

Re: How to get first 4 Weeks Sold Quantity?

sunny_talwar — Wed, 07 Dec 2016 18:59:58 GMT

Not sure if you want count or sum of SoldQty... See attached, I have both in there