Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

HI friends  i want to create a calendar based on date field but the problem is that date field contains only yyyy-mm.

1 Solution

Accepted Solutions
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.

View solution in original post

25 Replies
hariprasadqv
Contributor III

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

Hi,

Without date It might not be possible. if dates are there Master Calander concept will help you.

Not applicable

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

hi HARI

its a actual revenue data comes from a web based application monthly , so in date field date is not available is there any way to create calendar for i have to generate only quater month and financial year from this field.

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

Hi,

USe makedate() for creating date.

makedate(YEar,Month)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

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

I have tried that option too

but its not working it creating problem while linking calendar and my table

buzzy996
Honored Contributor II

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

use this,

Not applicable

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

Thanks shiva but i have to create a master calendar from it.

hariprasadqv
Contributor III

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

Ankith try this.

LOAD Sales,

    Purchases,

    [Gross Profit],

    Overheads,

    [Operating Profit],

    [Other Expense],

    [Other Income],

    [Other Expense/Income],

    [Net Income],

    Month as date,

    YEAR(Month) as Year,

    Month(Month) as Months,

    Num(Month(Month)) as MonthNumber,

    'Q' & ceil(month(Month) / 3) as Quarter

   

FROM

(biff, embedded labels);



Try to load data into the QV without Null values

Partner
Partner

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

add in your Script:

if(Len(Month) > 0,Date(Month&'-01','YYYY/MM/DD'),Null()) as MonthDate

Not applicable

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

not working hari...