topic LYTD sales in QlikView

LYTD sales

Fri, 20 Jan 2012 09:18:49 GMT

everyone,

i am stuck in the formula to calculate LYTD sales, i want to apply set analysis in it.

any suggestions.

regards

vijit

Re: LYTD sales

vijay_iitkgp — Fri, 20 Jan 2012 09:45:59 GMT

Hi Vinit,

You can use below formula where var1=Max(Year)-1 and var2=Date(Addmonths(Max(date),-12),'Format'). This will work for any date selection.

=Sum({$<[Clearing Year]={$(var1)}, Clearing_AUGDT={"(<=$(var2))"}>} [Amount in LC_DMBTR])

Re: LYTD sales

vijay_iitkgp — Fri, 20 Jan 2012 09:47:23 GMT

Read [Clearign Year] as Year and Clearing_AUGDT as Date

LYTD sales

Fri, 20 Jan 2012 10:40:44 GMT

hi vijay

thanx for your help but the formula provided by you gives only the sales of the maximum month last year.

I want the sales till date based on selection.

for eg:

if my maximum date is 30-11-2011 and maximum year is 2011.

then i want the sales of 2010 till november not only november.

hope you understand my problem.

LYTD sales

vijay_iitkgp — Fri, 20 Jan 2012 10:47:16 GMT

Hi,

I am using

If Year=LastYear and Date is less than lastyear todays date that means last YTD. the second condition is showing Date< = Todays date of last year. It is working fine for me and I am able to get the desired ressult. hope you have not selected any month in your filter.

LYTD sales

vijay_iitkgp — Fri, 20 Jan 2012 10:58:15 GMT

Hi Vijit,

If you select only year or date it will give you LYTD and if u select Month also then it will give LYMTD value