Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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
Highlighted
Creator III
Creator III

Hi,

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

Highlighted
Not applicable

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.

Highlighted

Hi,

USe makedate() for creating date.

makedate(YEar,Month)

Regards

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

I have tried that option too

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

Highlighted
Master II
Master II

use this,

Highlighted
Not applicable

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

Highlighted
Creator III
Creator III

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

Highlighted
Partner
Partner

add in your Script:

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

Highlighted
Not applicable

not working hari...