topic YTD and PYTD in QlikView

YTD and PYTD

ravindraa — Thu, 25 Jun 2015 07:12:36 GMT

Hi experts,

i have struk one place please give me any suggesion to come out.

in my applicaiton i have year filed and sales country fileds i have to show country wise YTD and PYTD sales.

with out selection it is shwoing exact valeus if i select PYTD values is not showing the sales

YTD condition is from selected year start to current month.

PYTD condition is selected year prevous year start till to same month of current month.

Ex: if we select 2015 PYTD need to be display 1/12014 to currrent month oflast year 6/25/2014.

Please give me any sugession .

Please see the attached files

thanks in advance.

Re: YTD and PYTD

arulsettu — Thu, 25 Jun 2015 07:30:16 GMT

check the attachment

Re: YTD and PYTD

ravindraa — Thu, 25 Jun 2015 08:27:52 GMT

Hi Arul Settu,

But if you select 2014 the YTD should display the 1-Jan-2014 to 25-June-2014 as YTD

in PYTD should display the 1-Jan-2013 to 25-june-214 like this

but here values is mismatching

please give me any suggesion

Re: YTD and PYTD

arulsettu — Thu, 25 Jun 2015 08:34:49 GMT

now check

Re: YTD and PYTD

Thu, 25 Jun 2015 11:10:00 GMT

Dear,

find attached file.

YTD & PYTD

let vmaxyear=max(Cal_year);

let vMaxDate=max(date)

YTD- sum({<Cal_year={$(vmaxyear)},cal_month=, date={"<=$(vMaxDate)"}>}sales)

Regards

Vimlesh

Re: YTD and PYTD

sasiparupudi1 — Fri, 26 Jun 2015 05:44:05 GMT

Use variables for your year and month selections and in the expressions,

YTD

sum({<Cal_year=, cal_month=,date={">=$(=MakeDate(vSelectedYear,1,1))<=$(=MakeDate(vSelectedYear,vSelectedMonth,1))"}>}sales)

PYTD

sum({<Cal_year=,cal_month=,date={">=$(=AddYears(MakeDate(vSelectedYear,1,1),-1))<=$(=AddYears(MakeDate(vSelectedYear,vSelectedMonth,1),-1))"}>}sales)

Re: YTD and PYTD

sasiparupudi1 — Mon, 29 Jun 2015 05:51:17 GMT

Did you come alright with the script?

Re: YTD and PYTD

Nirpanthan — Mon, 16 Dec 2019 12:24:40 GMT

=(Sum({<Periodname,Segment3={440},ToDate={">=$(vStartDate)<=$(vTillDate)"}>}Closingbalance)+
Sum({<Periodname,Segment3={470},ToDate={">=$(vStartDate)<=$(vTillDate)"}>}Closingbalance)+
Sum({<Periodname,Segment3={480},ToDate={">=$(vStartDate)<=$(vTillDate)"}>}Closingbalance))/vThousand

i am not getting for pytd can you help