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

[sunny_talwar]

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.

[devarasu07]

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,

[sunny_talwar]

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