topic YTD & MTD in QlikView

YTD & MTD

NavinReddy — Thu, 18 Jul 2013 11:26:56 GMT

Hi Community,

I have a table like this, i need to be find out the YTD and MTD Calls

Day of the Calls,

Year to date Calls,

Month To date Calls

could some help me

LOAD

MTD,

YTD,

Metricid

FROM

(ooxml, embedded labels, table is Sheet1);

Thanks,

Rohith

Thu, 18 Jul 2013 11:37:18 GMT

Try this....

Take Date field(DD/MM/YYYY) in script level..then try expression

YTD:

Sum({<Date={'>=$(=(Num(YearStart(Max(Date)))))<=$(=(Num(Date)))'}>}Calls)

MTD:

Sum({<Date={'>=$(=(Num(MonthStart(Max(Date)))))<=$(=(Num(Date)))'}>}Calls)

er_mohit — Thu, 18 Jul 2013 12:00:45 GMT

See the attached file

NavinReddy — Fri, 19 Jul 2013 04:11:28 GMT

Hi mohit ,

Thanks a lot

Plz find the attachment,let me know if i roung

Rohith