topic Re: MTD & LTD in set analysis in QlikView

MTD & LTD in set analysis

Wed, 01 Jan 2014 16:26:12 GMT

Hi All,

Happy new year to everyone!!!!!

I have req. as below and I need some help in this.

I have certain fields like Product,number,values,id,date,cal_month fields.

I need to calculate the MTD and LTD formulae’s with respect selection and without selection in front end level.

If I am selecting the particular month it has to show the values with that particular month like values upto that month(Live Till Date) and values(MTD i.e only that particular month) in one chart
2.If am not selecting any list box it has to values LTD(till the date) and MTD(only current month) in one chart.

Plz find the attached sample data and I am unable to attach the original data.

Thanks in advance,

Ravi

Anonymous — Thu, 02 Jan 2014 10:42:02 GMT

Hi,

Please check attached.

Hope this helps.

Regards,
Aadil

VishalWaghole — Thu, 02 Jan 2014 11:19:11 GMT

You can try this, Hope it will helpful for you..

LTD:
= sum({< Revenue_Date= {">=$(=Date(YearStart(min(Revenue_Date))))<=$(=max(Revenue_Date))" }>}GrossRevenue)

MTD:

= sum({<Revenue_Date= {">=$(=Date(MonthStart(Max(Revenue_Date))))<=$(=max(Revenue_Date))" }>}
GrossRevenue)

- Regards,

Vishal Waghole

brijesh1991 — Thu, 02 Jan 2014 12:57:44 GMT

Create a variable

vMonth = Max(Date); where Date is your calender date

For LTD,

count({$<Set Analysis if anything you have>}if (InMonthToDate ( Revenue_Date, '$(vMonth)', 0), CallID))

For MTD:

vMonthEnd= date(floor(monthend('$(vMonth)')), 'DD/MM/YYYY')

count

({$<Set Analysis if anything you have>}if (InMonthToDate ( Revenue_Date, '$(vMonthEnd)', 0), CallID))

stevedark — Thu, 02 Jan 2014 23:50:42 GMT

Hi,

You may find these examples helpful for prior period comparison using Set Analysis:

- Steve