Create a Calandar tab amd Use a script like this
Load min(Link_Master_Calendar) as StartDate,
max(Link_Master_Calendar) as EndDate
Let vSTART = peek('StartDate',-1,'Range')-1;
Let vEND = peek('EndDate',-1,'Range');
Let vRANGE = $(vEND) - $(vSTART);
Let vTODAY = num(date(today()));
Drop Table Range;
Load $(vSTART)+recno() as Date
Load dATE(Date,'dd/MM/YYYY') as Link_Master_Calendar,
dATE(Date,'dd/MM/YYYY') as FullDate,
Year(Date) as Year,
Month(Date) as Month,
Week(Date) as Week,
'Q'&ceil(Month(Date)/3) as Quarter,
Month(Date)&'-'&right(Year(Date),2) as [Month Year]
Drop Table Dates;
Finally change Link_Master_Calendar to your actual date fields.
I'm using a special calendar for the script because i have to take the 15 days of prev month to the 15 days of the actual month. So in my script i have:
In the code file cause i can't put the script here
code.txt 2.3 K
I found a part of the question. In fact i checked "Display all the values" in dimention options of the table.
But it display me all the values of the calendar, like even if i make a selection on 2012 value, I will have 2006 - 2007 ....
So i made a calculated dimention: =if(year([Date création]), MMYYYY)
MMYYYY = Month + year.
But it display me only the data if there is a creation date for the month. So i have nothing in december in creation date, so i won't have december in my table.
And I want to have december even if it's displayed with value 0.
Do you have an idea?
As per i can understand- u can do d following-
suppose u have atable wit values and dates..... suppose 2000 = 10,2001=14,2003=15.
now u have a calender which have dates 2000,2001,2002,2003,2004,2005..
so u want to see in chart as :
now to get d above
1.- dont link table wit calender date( kip both separate)
2 - in dimension u take calender dates and in expression - if (cal=table date, values)
3 - uncheck mark - from presentation tab - suppress zero values and suppress missing and null symbol give '0' ans missing symbol give '0' instaed of '-'
i hope diz shud work......
Yes i think it's what i have:
LOAD * INLINE [Date création] ;
And the only one link with my data table is [Date création] ;
I have to have this for the charts and tables, for doing a relation with them.
in the table where there is [Date création] ;, I have some other information.
So it's like if [Date création] would be the "Values" you say I think.
I have a calculated dimention:
=if(month([Date création DCP]), MMYYYY)
- Delete if nul values (in Dimentions)
- Delete nul values (in Presentation)
- Delete missed Values (in Presentation)
- Display all values (in Dimentions)
So do you have an idea please? did i make a mistake?