topic Re: Hi, in QlikView

Hi,

Wed, 25 Nov 2020 16:16:04 GMT

how to calculate the YTD Sales and MTD Sales, QTD Sales but Make sure my calendar year starts with the 1-OCT.

Thankyou,

Siva

adamdavi3s — Wed, 22 Feb 2017 07:20:02 GMT

Hi Siva,

Use a master calendar with flags, check out the search box at the top right, it will help you a lot

sasikanth — Wed, 22 Feb 2017 07:20:56 GMT

HI,

There are some functions available to compute .

1) YearStart(), YearEnd()

Sum({<Date={">= $(=YearStart(max(Date)) ) <= $(=max(Date)) "},YEAR=,MONTH=>}SALES)

2) MonthStart(), MonthEnd()

Sum({<Date={">= $(=MonthStart(max(Date)) ) <= $(=max(Date)) "},YEAR=,MONTH=>}SALES)

3) Quarterstart(), QuarterEnd()

Sum({<Date={">= $(=QuarterStart(max(Date)) ) <= $(=max(Date)) "},YEAR=,MONTH=>}SALES)