topic how i can get analysis between purticular dates in QlikView

how i can get analysis between purticular dates

Tue, 14 Jan 2014 11:44:46 GMT

how i can get analysis for particular period(say from 10th july 2005 to 7th july 2010)

I am using two calendar object

and I have given the field orderdate for both the calendar object

but as it is coming from the same orderdate field the moment I select one date that same date gets selected in other calendar object

I tried using the resident concept by setting orderdate1 and tried using orderdate for one calendar object and orderdate1 for second calendar object but that is also not working

Re: how i can get analysis between purticular dates

vikasmahajan — Tue, 14 Jan 2014 11:55:12 GMT

try following expression

SUM({$<FiscalYear={$(=max(FiscalYear)-1)},YEAR_MONTH=p(YEAR_MONTH_PREVIOUS),[Posting Date]={'<=$(vLMaxDate)'},FinancialYear=,MonthName= >} [Sales Amount])

1. YEAR_MONTH_PREVIOUS is filed to create in calender master is as follows

num((Year(TempDate)-1)&num(Month(TempDate),'00')) AS YEAR_MONTH_PREVIOUS, // Link between tables for previous month / year selection

2. vLmaxdate is variable

=date(addyears(max([Posting Date]), -1), 'DD/MM/YYYY')

Hope this helps you for previous year ytd vs curr year ytd ( Like wise comparison)

http://community.qlik.com/thread/102332

Vikas

Re: how i can get analysis between purticular dates

Colin-Albert — Tue, 14 Jan 2014 12:01:13 GMT

Have a look at this example

http://community.qlik.com/docs/DOC-5598