topic Re: Comparing holiday periods in QlikView

Comparing holiday periods

dafnis14 — Wed, 29 Apr 2015 10:56:46 GMT

Hi,

I have a request to generate a similar report to the one attached below (Excel).

The idea is to compare a selected holiday period to the same holiday in a previous year.

Another request is to enable the user to define a number of days before and after the holiday period. Which means that the calculations have to be on the fly, and not in script.

I was thinking about using alternate states, but not sure whether this is a good direction.

I would appreciate some guidelines.

Thanks!

Message was edited by: Dafnis X

Re: Comparing holiday periods

jpenuliar — Wed, 29 Apr 2015 11:07:42 GMT

Hi,

Can you post sample data

Re: Comparing holiday periods

dafnis14 — Wed, 29 Apr 2015 11:24:37 GMT

Hi,

I just did..

Thanks!

Re: Comparing holiday periods

jpenuliar — Wed, 29 Apr 2015 13:12:35 GMT

the attachment is basically the report you want to achieve,

Do you have source data, table/s where the report takes data from?

Re: Comparing holiday periods

dafnis14 — Wed, 29 Apr 2015 16:36:05 GMT

Hi Jonathan,

You are right. I should have attached real data. I'll do that later.

But regardless of the holidays – is it possible to generate such a chart at all?

Thanks!

Re: Comparing holiday periods

jpenuliar — Thu, 30 Apr 2015 08:37:30 GMT

Hi Dafnis,

I believe it is possible, a pivot Table object might do the trick.

Re: Comparing holiday periods

dafnis14 — Thu, 30 Apr 2015 10:41:09 GMT

Hi,

I attached a simplified data model.

Thanks!

Re: Comparing holiday periods

jpenuliar — Thu, 30 Apr 2015 13:42:47 GMT

Hi Dafni,

have a look at attached file using pivot, not exactly as your attached image but nearly there. I only done a define year selection, you can make the current year/previous year dynamic or based on selection.

Have a look at sample / demo files to get an idea how you be able to present Comparison in different ways.

Re: Comparing holiday periods

dafnis14 — Thu, 30 Apr 2015 17:03:19 GMT

That's very cool!

Thanks!

I could never think about such a solution..

Re: Comparing holiday periods

dafnis14 — Fri, 01 May 2015 16:00:33 GMT

Hi Jonathan,

I would appreciate if you could advise regarding a dynamic year option.

For example, if a year is selected, the previous year dates are calculated like that:

Only({<year ={"$(=max(year)-1)"}>}HolidayDate)

I have updated the Sales expression as follows:

Sum({<year ={"$(=max(year)-1)"}>Sales)

but no values are shown...

Can you help me to figure why?

Thanks!