Re: How to create Finacial Year Calender?????? - Qlik Community

balasundaram · ‎2014-09-04

plz give me how to create financial Year

ashfaq_haseeb · ‎2014-09-04

Hi,

have a look at below post.

http://community.qlik.com/docs/DOC-7094

Regards

ASHFAQ

vikasmahajan · ‎2014-09-04

Please refer SIMPLE MASTER CALENDER

link

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

aveeeeeee7en · ‎2014-09-04

Hi

Do this in you backend Script:

YearName(YourDateField,0,4) // Parameter 4 will start your Finacial Year from April to March.

eg. 2014-2015 Financial Year Start from

Apr2014

May2014

Jun2014

Jul2014

Aug2014

Sep2014

Oct2014

Nov2014

Dec2014

Jan2015

Feb2015

Mar2015

See the Attachment.

Regards

Aviral Nag

Report Inappropriate Content · ‎2014-09-04

get the min and max date from the fact table.

then iterate the date from min until max is met. Then transform the load as per requirement

http://www.rhyous.com/2009/11/20/how-to-create-a-calendar-in-qlikview/

balasundaram · ‎2014-09-05

Can you tell expression for Current Financial Year vs Previous Financial Year expressions in Barchart?

Anonymous · ‎2014-09-05

=(Sum({<FiscalYearQuarterStart={">=$(=Date(MAX(FiscalYearStart)))<=$(=Date(MAX(FiscalYearQuarterStart)))"},FinancialYear=,FiscalQuarter=,WeekKey=>}Amount)-

Sum({<FiscalYearQuarterStart={">=$(=Date(ADDMONTHS(MAX(FiscalYearStart),-12)))<=$(=Date(ADDMONTHS(MAX(FiscalYearQuarterStart),-12)))"},FinancialYear=,FiscalQuarter=,WeekKey=>}Amount))