topic YTD Calculation For Specific Date in QlikView

YTD Calculation For Specific Date

Mon, 10 Aug 2009 18:42:36 GMT

Hello all,

Probably a simple question really but here goes. I have an application whereby I want to build a YTD, MTD and QTD sales total within a Straight Table. I want the user to be able to click on a specific date (e.g. 28/02/2008) and be able to get the sales totals up to that date.

So for example if the user selects 28/02/2008 as a date from a list box, then the YTD sales will consist of all sales values from 01/01/2008 up to and inclusive of 28/02/2008. I also need to create the same but for the previous year so that the sales total would show 01/01/2007 to 28/02/2007.

Not really sure how to go about this, i've tried playing with if statements but have failed in creating a solution.

Any ideas anyone?

Cheers

YTD Calculation For Specific Date

Mon, 10 Aug 2009 20:37:05 GMT

Hi again Guys,

Dont worry, cracked it, or at least I think so. For anyone interest this is the way I built the solution:

YTD - sum({1 < Report_DATE = {'>=$(=date(yearstart(Report_DATE))) <=$(=date(Report_DATE))'} >} Calc_Sales)

QTD - sum({1 < Report_DATE = {'>=$(=date(quarterstart(Report_DATE))) <=$(=date(Report_DATE))'} >} Calc_Sales)

MTD - sum({1 < Report_DATE = {'>=$(=date(monthstart(Report_DATE))) <=$(=date(Report_DATE))'} >} Calc_Sales)

Tryng to get the previous year ones working now, which should be fun.

Cheers,

YTD Calculation For Specific Date

qliksus — Thu, 26 Nov 2009 13:52:46 GMT

Hi paul,

I just go through your MTD solution . Exact similar type of expression i have written and it is working well but i want at this time MTD of prev month also. Can you give me any idea to solve ??? I treid with addmonth but it is giving 0.