topic Re: Calculating YTD and MTD in Load Script in QlikView

Calculating YTD and MTD in Load Script

Wed, 20 Mar 2013 11:55:01 GMT

Hi All,

Is thee any way to calculate the YTD in Load Script?

I have calculate the daily slaes like below,

FinalSales:

Load

DATE(SALESDATE,'DD/MM/YYYY')AS SALESDATE,

sum(STORE_SALES_AMT_CY) as DailySales

resident Fact_Sales group by SALESDATE;

Now i want to calculate the YTD and MTD for the same

Load

DATE(SALESDATE,'DD/MM/YYYY')AS SALESDATE,

sum(STORE_SALES_AMT_CY) as YTD

resident Fact_Sales where min date in that year to Max date in that year group by SALESDATE;

Kindly help,

Thanks,

Selva

Gysbert_Wassenaar — Wed, 20 Mar 2013 12:01:55 GMT

See here. Once you've calculated the YTD and MTD flags you can also calculate the sums in the script if you want.

Wed, 20 Mar 2013 12:11:39 GMT

Hi Gysbert,

But i don't want to use set analysis. I have to calculate in Load it self and store it in CSV directly.

Thanks,

Selva