How to get first 4 Weeks Sold Quantity?

[devarasu07]

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

[tresesco]

Try like:

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

[Anil_Babu_Samineni]

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)

[devarasu07]

HI,

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

Regards,Dev

[devarasu07]

Hi Anil,

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

[tresesco]

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)

[devarasu07]

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

[sunny_talwar]

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

[devarasu07]

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)

[devarasu07]

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)