topic Re: logic Help in QlikView

logic Help

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

pls help me in this, need the year start date of as per fiscal year, when selecting the dates,

attaching sample file and data.

when user select 30.04.2016, year start shud be as per fiscal year which is 01.04.2016

when user select 31.03.2016, year start shud be as per fiscal year which is 01.04.2015

Re: logic Help

PrashantSangle — Thu, 12 May 2016 11:38:37 GMT

Hi,

Try,

YearName(DateField,0,,4)

Regards

Re: logic Help

swuehl — Thu, 12 May 2016 11:43:19 GMT

Try as expression

=Yearstart(Min(Dates),0,4)

Re: logic Help

ajsjoshua — Thu, 12 May 2016 11:44:04 GMT

Hi,

SET vFiscalYearStartMonth = 4;

LET vStartDate = Num(YearStart(Today(), -1));

LET vEndDate = Num(YearEnd(Today()));

FiscalCalendar:

LOAD

Dual('Q' & Ceil(FiscalMonth/3), Ceil(FiscalMonth/3)) AS FiscalQuarter, // Fiscal Calendar Quarter

Dual(Text(Date(MonthEnd(Date), 'MMM')), FiscalMonth) AS FiscalMonthName; // Fiscal Calendar Month Name

LOAD

Year(Date) AS Year, // Standard Calendar Year

Month(Date) AS Month, // Standard Calendar Month

Date(MonthEnd(Date), 'MMM') AS MonthName, // Standard Calendar Month Name

Dual('Q' & Ceil(Month(Date)/3), Ceil(Month(Date)/3)) AS Quarter, // Standard Calendar Quarter

Mod(Month(Date) - $(vFiscalYearStartMonth), 12)+1 AS FiscalMonth, // Fiscal Calendar Month

YearName(Date, 0, $(vFiscalYearStartMonth)) AS FiscalYear; // Fiscal Calendar Year

LOAD

Date($(MinDate) + RangeSum(Peek('RowNum'), 1) - 1) AS Date,

RangeSum(Peek('RowNum'), 1) AS RowNum

AutoGenerate MaxDate- MinDate+ 1;

Load

Min(FactDate) AS MinDate,

Max(FactDate) AS MaxDate

RESIDENT FactTableName;

Re: logic Help

Anonymous — Thu, 12 May 2016 11:52:12 GMT

Will this work?

Re: logic Help

sunny_talwar — Thu, 12 May 2016 12:24:25 GMT

Just out of curiosity, how come most of your discussion thread are titled "Logic Help" abhay‌? Is it that difficult to come up with a decent title for your discussion threads

Try to be concise, but descriptive in your titles buddy. These titles are not helpful for people who might be having similar issues in the future because the title is vague and there are no tags.

Although you are getting decent responses to your questions, but I would still suggest that please spend a little time to give back to this community (who has helped you almost always) by doing a little extra hard work on your end

QlikCommunity Tip: How to get answers to your post?

Best,

Sunny

Re: logic Help

msdeepak — Thu, 12 May 2016 12:48:07 GMT

Sunny, maybe there is some science behind that? The word Logic may kind of trigger a curiosity in the members to view and resolve it like a challenge. So I would concur there is a "logic" behind this approach

-Deepak