topic Displaying last 8 weeks Data in QlikView

Displaying last 8 weeks Data

Saro_2306 — Fri, 03 Sep 2021 09:45:18 GMT

Hi All,

I having 2 Years data. i need to show last 8 weeks data based Selection of Week. when i selecting particular week i shows sum of 2 week data i/o current year Data.

For ex. If i have data of Year 2019 & 2020 and selecting week 26 & Year 2020, my bar chart should show data week 19 to 26 of 2020. but is shows sum of 2019 & 2020.

Formula that i used.

Sum({<Week_no={"<=$(=(max(Week_no)))>=$(=(max(Week_no)-7))"},Month,Year>}MD)

Anybody can help please. Thanks in Advance.

Re: Displaying last 8 weeks Data

Chanty4u — Sun, 05 Sep 2021 16:01:10 GMT

May be try this

vMaxDate: =Date(Max(DATE))

vPrior8WeekPeriod: =Date(RangeMax(vMaxDate - 56, Min({1} DATE)))

=SUM( {<DATE={'>= $(vPrior8WeekPeriod) <= $(vMaxDate)'}>} [Amount] )

Re: Displaying last 8 weeks Data

MarcoWedel — Wed, 08 Sep 2021 20:22:12 GMT

can you please post some sample data as well as your expected result to test with?

thanks

Marco