topic Re: small requirement in QlikView

small requirement

prma7799 — Mon, 06 Jul 2015 09:36:29 GMT

Hi All,

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

PFA

Thanks

Re: small requirement

jagan — Mon, 06 Jul 2015 09:44:32 GMT

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.

Re: small requirement

ThornOfCrowns — Mon, 06 Jul 2015 09:45:31 GMT

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.

Re: small requirement

svenkita — Mon, 06 Jul 2015 09:58:44 GMT

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

Re: small requirement

prma7799 — Mon, 06 Jul 2015 10:21:09 GMT

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

Re: small requirement

jagan — Mon, 06 Jul 2015 10:27:47 GMT

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

Re: small requirement

prma7799 — Mon, 06 Jul 2015 10:48:52 GMT

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

Re: small requirement

jagan — Tue, 07 Jul 2015 02:34:03 GMT

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.

Re: small requirement

prma7799 — Tue, 07 Jul 2015 04:10:02 GMT

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.

Re: small requirement

jagan — Tue, 07 Jul 2015 05:03:57 GMT

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.

Re: small requirement

jagan — Tue, 07 Jul 2015 05:04:52 GMT

Hi,

PFA file for solution.

Regards,

Jagan.

Re: small requirement

prma7799 — Tue, 07 Jul 2015 05:50:29 GMT

Hi Jagan,

Your attachment is correct but can you please tell me about underline. Means when i select Overview then it will come with underline.

Thanks

Re: small requirement

jagan — Tue, 07 Jul 2015 05:53:47 GMT

Hi,

Use Line/Arrow objects based on the button clicked show and hide the Line object. Create separate Line objects for each buttons, based on the button click show the lines.

Regards,

Jagan.