Master Calendar

[honeyasha]

Hi ,

can any one explain the previous month and prior month sales in set analysis using master calendar with example.

Thanks in advance.

[ecolomer]

Yoiu can see this:

Previous three months

[jyothish8807]

Hi Rohini,

The below thread would be helpful in understanding Master calendar.

Creating A Master Calendar

To calculate previous month and current month sales try like this:

Curr Month Exp: sum({<Year={'$(=Year(max(Year))'},Month={'$(=Month(max(Month))'}>}Sale)

Pre Month Exp: sum({<Year={'$(=Year(max(Year))'},Month={'$(=Month(addmonths(max(Month),-1))'}>}Sale)

Br,

KC

[ecolomer]

And this:

QlikView App: Set Analysis - Prior Period Comparison

[jyothish8807]

Why is my comments moderated now a days ?

Br,

KC

[arvind1494]

Suppose,

Date is a field in your master calender:

Prior month:

1) sum({$<Year, Month, Date = {"$(='>=' & Date(MonthStart(Max(Date))) & '<=' & Date(MonthEnd(Max(Date))))"}>} Sales)

Previous month:

2) sum({$<Year, Month, Date = {"$(='>=' & Date(MonthStart(Max(Date), -1)) & '<=' & Date(MonthEnd(Max(Date), -1)))"}>} Sales)

[honeyasha]

Thanks for all your response.

I have created a Master Calendar but for particular Date sales has not been done but still sales is reflecting for that date.

Can anyone explain .

Thanks.

[ecolomer]

Can you upload a file with an example?

[honeyasha]

Hi Enrique,

Thanks for response,

I have fixed that issue . I want to know about previous & current month,Year & quarter sales expression in set analysis with example  and i have created Master calendar.

Thanks in advance.

[jyothish8807]

Hi Rohini,

Try this:

To calculate previous month and current month sales try like this:

Curr Month Exp: sum({<Year={'$(=Year(max(Year))'},Month={'$(=Month(max(Month))'}>}Sale)

Pre Month Exp: sum({<Year={'$(=Year(max(Year))'},Month={'$(=Month(addmonths(max(Month),-1))'}>}Sale)

Br,

KC