small requirement

[prma7799]

Hi All,

I have some requirement can you please give me some ideas on this.

PFA

Thanks

[jagan]

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.

[ThornOfCrowns]

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.

[svenkita]

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

[prma7799]

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

[jagan]

Did you used above script?  If yes then you can easily sort it in the front end.

[prma7799]

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

[jagan]

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.

[prma7799]

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.

[jagan]

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.