Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

Dynamic financial year set analysis

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

7 Replies
joaquinlr
Specialist II
Specialist II

Hello :

Please read this document, maybe help you.

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

vikasmahajan
Author

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

joaquinlr
Specialist II
Specialist II

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
Author

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

joaquinlr
Specialist II
Specialist II

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
Author

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

joaquinlr
Specialist II
Specialist II

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