Data Reduction - Calendar issue

[eliran]

Hi All,

I got a small problem with calendar table while doing data reduction to a model.

I get only the dates of the related invoices, so if there wasn't a transaction at feb 2012, I wont see Feb under month field.

The basic data reduction model is:

Company table, Invoices which connected to the company, and the reduction is being done according to the company id.

Thanks for the help,

Eliran.

[Anonymous]

Do you have a master calendar set up that has a full uninterupted timeseries of dates from a starting to an ending date. See this post for example: http://community.qlik.com/message/291974#291974

Jonathan

[eliran]

Jonatahn,

Thanks for replying, Yes I have a master calendar.

The master calendar is connected to the invoices, the invoices are connected to the companies, the data reduction is connected to the companies.

Whenever the user have access to only several companies, he sees partial calendar info.

Full access users can view full calendar info.

Regards,

Eliran.

[Anonymous]

Can you try connecting company, invoices and calendar to a link table.

Jonathan