topic Re: Data Reduction - Calendar issue in QlikView

Data Reduction - Calendar issue

eliran — Wed, 09 Jan 2013 09:45:11 GMT

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.

Re: Data Reduction - Calendar issue

Anonymous — Wed, 09 Jan 2013 11:24:32 GMT

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

Re: Data Reduction - Calendar issue

eliran — Wed, 09 Jan 2013 11:56:41 GMT

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.

Re: Data Reduction - Calendar issue

Anonymous — Wed, 09 Jan 2013 12:23:40 GMT

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

Jonathan