Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have some requirement can you please give me some ideas on this.
PFA
Thanks
Hi,
You need to create a master calendar with Fiscal dates, please check below link hope it helsp you.
Fiscal and Standard Calendar generation
Regards,
Jagan.
What have you tried and what problems did you encounter?
Have you tried searching this community for possible answers?
Have you done a general search for likely answers?
etc., etc.
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='D/MM/YYYY';
SET TimestampFormat='D/MM/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
LET vDateMin = Num(MakeDate(2013,4,1));
LET vDateMax = Num(MakeDate(2016,3,11));
TempCalendar:
LOAD $(vDateMin) + RowNo() - 1 AS DateNumber,
Date($(vDateMin) + RowNo() - 1) AS TempDate
AUTOGENERATE 1
WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);
Star_Calendar:
Load
TempDate As StarDate,
YearName(TempDate,0,4) As StarFiscalYear,
if(index(yearname(TempDate,0,4),'-')>0,
subfield(yearname(TempDate,0,4),'-',2),
year(TempDate)) As StarFiscalBudgetYear,
'Q'&
if (Num(Month(TempDate)) = 4 , 1,
if (Num(Month(TempDate)) = 5 , 1,
if (Num(Month(TempDate)) = 6 , 1,
if (Num(Month(TempDate)) = 7 , 2,
if (Num(Month(TempDate)) = 8 , 2,
if (Num(Month(TempDate)) = 9 , 2,
if (Num(Month(TempDate)) = 10 , 3,
if (Num(Month(TempDate)) = 11 , 3,
if (Num(Month(TempDate)) = 12 , 3,
if (Num(Month(TempDate)) = 1 , 4,
if (Num(Month(TempDate)) = 2 , 4,
if (Num(Month(TempDate)) = 3 , 4,
)))))))))))) As StarFiscalQuarter,
month(TempDate) As StarMonth,
Year(TempDate) As StarYear,
day(TempDate) As StarDay,
monthname(TempDate) As StarRollMonth,
week(TempDate) As StarWeek,
weekname(TempDate) As StarWeekName,
weekday(TempDate) As StarWeekDay,
if(weekday(TempDate)>=5,'WeekEnd','WeekDay') As StarWeekEnd,
QuarterName(TempDate,0,4) As StarQuarter
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;
LET vDateMin = "";
LET vDateMax = "";
LET vDateToday = "";
Attached is the sample
Hi Jagan,
I have already created calendar.
I just want to change order for front end.
and about text object i want underline when i select them.
Thanks
Did you used above script? If yes then you can easily sort it in the front end.
Yes I using can you please tell me how sort it in front end and how can i get underline when i select on text object
Thanks
Hi,
Go through this link and you will know how to get answers quickly for your requirement.
Qlik Community Tip: Posting Successful Discussion Threads
If you post sample attachments then it would be easier to analyse and provide solution.
Regards,
Jagan.
Hi Jagan,
I gone through above link and i understood that.
Thanks
PFA
In that attachment i used button .
My requirement is when i select Overview or Trend etc... I want underline for selected objects.
Many thanks in advance.
Hi,
Try like this
For Overview button
Properties -> General -> Color -> Select Calculated -> Give =If(GetActiveSheetId() = 'Document\SH01', Green(), RGB(119, 187, 255))
And set Transparency to 0%.
Regards,
Jagan.