Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Partner
Partner

Re: hi friends i want to create a calendar dased on date field.

does this code work on your app?

Date_src:

LOAD

$(Start) + Rowno() -1 as DateId

AUTOGENERATE $(NumOfDays);

Not applicable

Re: hi friends i want to create a calendar dased on date field.

it is creating problem while linking..will u pls create sample for me ...

Partner
Partner

Re: hi friends i want to create a calendar dased on date field.

Have a look at attached file.

Not applicable

Re: hi friends i want to create a calendar dased on date field.

thank you jonathan ....

Not applicable

Re: hi friends i want to create a calendar dased on date field.

did u check the subset ratio....its 1 % in pnl..pls check

Partner
Partner

Re: hi friends i want to create a calendar dased on date field.

That is because your fact table only has dates Mapped to the First Day of the months, where as the Calendar has all the Dates generated. If you want to match the subset ratio, you will have to delete all the other dates except the first of the month.

Since you will only have 24 rows (2014 to 2015 months) you can probably create an xls version of the Master Calendar and manually input data.