Dynamic financial year set analysis

[vikasmahajan]

Dear all

I have following expression here I want to take dynamic financial year  as per user selected  '2012-2013' or '2013-2014'

how to achive the same ?

Follow are the my expresssion

SUM({$<FiscalYear={$(=max(FiscalYear))},TarFinyr={'2013-2014'}>} [DivAnnualTgt])/100

Thanks in advanace

Vikas

[JoaquinLazaro]

Hello :

Please read this document, maybe help you.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

[vikasmahajan]

Thanks for Reply I dont Want Hard coded I want as per user sel

[JoaquinLazaro]

Vikas Mahajan

Read the previous document, add the fiscal year into your master calendar.

Then, update the selection items to work with new fiscal year field instead of calendar (usual) year field

[vikasmahajan]

Dear Sir

Thanks for your input  I want to display if user selected '2013-2014'  then my expression is  hardcoded I don't want hard coded I want Dynamic.

SUM({$<FiscalYear={$(=max(FiscalYear))},TarFinyr={'2013-2014'}>} [DivAnnualTgt])/100

Please give solution.

Vikas

[JoaquinLazaro]

1) Create a new list box object on your sheet

2) Select the field TarFinyr on the general tab

3) Remove TarFinyr={'2013-2014'} on your expression

[vikasmahajan]

Thanks for your reply I want to use financial year for user selections linked with tarfinyr any Idea how to achive the same.

Thanks.

Vikas

[JoaquinLazaro]

Hi Vikas:

In the first answer I wrote you a link to a Technical Brief about deploying Fiscal Year.

You need:

1) A fact table (invoincing o accounting) with a date

2) A master calendar with at least two columns: date to link wiht the fact table and fiscal year of this date

3) Create a ListBox over the new fiscal year field ... see my previous post.

When your user select one or more values on the ListBox the associative capabilities of QV will do the job