topic Re: Master Calendar in QlikView

Master Calendar

honeyasha — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

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

Thanks in advance.

Re: Master Calendar

ecolomer — Sun, 10 Jun 2018 06:30:45 GMT

Yoiu can see this:

Previous three months

Re: Master Calendar

jyothish8807 — Sun, 10 Jun 2018 06:33:06 GMT

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,

Re: Master Calendar

ecolomer — Sun, 10 Jun 2018 06:47:16 GMT

And this:

QlikView App: Set Analysis - Prior Period Comparison

Re: Master Calendar

jyothish8807 — Sun, 10 Jun 2018 07:07:35 GMT

Why is my comments moderated now a days ?

Br,

Re: Master Calendar

arvind1494 — Sun, 10 Jun 2018 09:16:20 GMT

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)

Re: Master Calendar

honeyasha — Sun, 10 Jun 2018 12:51:37 GMT

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.

Re: Master Calendar

ecolomer — Sun, 10 Jun 2018 14:10:32 GMT

Can you upload a file with an example?

Re: Master Calendar

honeyasha — Sun, 10 Jun 2018 14:20:56 GMT

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.

Re: Master Calendar

jyothish8807 — Mon, 11 Jun 2018 04:36:16 GMT

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,

Re: Master Calendar

honeyasha — Mon, 11 Jun 2018 16:59:23 GMT

Hi Jyothish,

Thanks for response ,

Both expression is not working in text object and straight table.

I am using Master calendar ,so i need to calculate current month and previous month sales.

Thanks.

Re: Master Calendar

jyothish8807 — Mon, 11 Jun 2018 17:13:41 GMT

Could you please share your master calendar script ?

Br,