topic Re: Dynamic financial year set analysis in QlikView

Dynamic financial year set analysis

vikasmahajan — Tue, 04 Jun 2013 09:45:11 GMT

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

Joaquin_Lazaro — Tue, 04 Jun 2013 09:55:58 GMT

Hello :

Please read this document, maybe help you.

vikasmahajan — Tue, 04 Jun 2013 10:09:00 GMT

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

Joaquin_Lazaro — Tue, 04 Jun 2013 10:13:41 GMT

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 — Tue, 04 Jun 2013 10:38:07 GMT

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

Joaquin_Lazaro — Tue, 04 Jun 2013 13:34:27 GMT

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 — Thu, 06 Jun 2013 03:45:05 GMT

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

Joaquin_Lazaro — Thu, 06 Jun 2013 09:15:13 GMT

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