Solved: hi friends i want to create a calendar dased on da... - Qlik Community

Report Inappropriate Content · ‎2015-04-09

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

jpenuliar · ‎2015-04-10

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

hariprasadqv · ‎2015-04-09

Hi,

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

Report Inappropriate Content · ‎2015-04-09

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.

PrashantSangle · ‎2015-04-09

Hi,

USe makedate() for creating date.

makedate(YEar,Month)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2015-04-09

I have tried that option too

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

buzzy996 · ‎2015-04-09

use this,

Report Inappropriate Content · ‎2015-04-09

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

hariprasadqv · ‎2015-04-09

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

jpenuliar · ‎2015-04-09

add in your Script:

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

Report Inappropriate Content · ‎2015-04-09

not working hari...

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