topic Re: inyeartodate in QlikView

inyeartodate

Wed, 25 Nov 2020 16:16:04 GMT

Hi i try to make an xy diagram with long and short term movement from budget

(X)

=(Sum(if(InMonth(Datum,Today(),0-vMonth),$(Volume)))

Sum(if(InMonth(Datum,Today(),0-vMonth),$(vBudgetVolym))))-1

(Y)

=(Sum(if(InYearToDate(Datum,Today(),0,4),$(Volume)))

Sum(if(InYearToDate(Datum,Today(),0,4),$(vBudgetVolym))))-1

i have implemented a button that change month vmonth in the X axis but i cant make it to work in the Y axis

if vmonth=-2 i want inyeartodate to be untill 2 month ago.

Re: inyeartodate

swuehl — Thu, 11 Aug 2016 18:36:27 GMT

Could you post a small sample QVW and describe a bit more detailed what the issue is (or where the result deviates from your expectation)?

Re: inyeartodate

Tue, 16 Aug 2016 06:00:44 GMT

Hi, the result deviates from my expectations in (Y) then i change vmonth

i have tried this but no change in the result

=(Sum(if(InYearToDate(Datum,Today(),0,4)-vMonth,$(Volume)))

Sum(if(InYearToDate(Datum,Today(),0,4)-vMonth,$(vBudgetVolym))))-1

its like InYearToDate cant be changed

Re: inyeartodate

swuehl — Tue, 16 Aug 2016 07:14:04 GMT

InYearToDate() returns a boolean flag (FALSE / TRUE or 0/-1), then you subtract your variable vMonth from the returned boolean value, is this what you want?

Re: inyeartodate

Tue, 16 Aug 2016 07:21:17 GMT

yes/no

i want to lower the range from InYearToDate(Datum,Today(),0,4) =20160401-20160816 today

into

20160401-20160731 vmonth=-1

20160401-20160630 vmonth=-2

20160401-20160531 vmonth=-3

Re: inyeartodate

swuehl — Tue, 16 Aug 2016 09:05:32 GMT

Maybe like

=InYearToDate(Datum, RangeMin(Today(), Monthend(Today(),vmonth)),0,4)

Re: inyeartodate

Tue, 16 Aug 2016 10:08:13 GMT

thank you