topic set analysis in QlikView

set analysis

denis115 — Fri, 10 Sep 2021 15:21:14 GMT

Hi everyone!

I'm stucked...

Having dimension DBZ (sales-costs) that is calculated in script

I need to create a chart that will show current(selected date) dbz, 1-30 days before dbz, 31-60 days before dbz and so one,

Ive tried: sum({$<DATE= {">$(=MAX(DATE-60))<$(=MAX(DATE)-31))"}> } DBZ)

and no results(((

help please

sunny_talwar — Fri, 10 Sep 2021 15:23:39 GMT

May be this

Sum({$<DATE = {">$(=Date(Max(DATE)-60))<$(=Date(Max(DATE)-31))"}>} DBZ)

denis115 — Fri, 10 Sep 2021 15:33:01 GMT

Ive tried this but it didnt worked

denis115 — Fri, 10 Sep 2021 15:35:47 GMT

Sum ( {<Month_NUM={"$(=max(Month_NUM)-1)"}>}DBZ)

where Month_NUM is number of month but its not good because when i will choose january it will not work

sunny_talwar — Fri, 10 Sep 2021 15:44:01 GMT

So use MonthYear instead... and use AddMonths() function to go back months

denis115 — Fri, 10 Sep 2021 15:59:27 GMT

Sum({$<MonthYear = {">$(=max( MonthYear ))<$(=max( MonthYear )+29)"}>} DBZ)

doesnt work(

sunny_talwar — Fri, 10 Sep 2021 16:28:08 GMT

You need to provide more details as to how are you creating MonthYear in the script?