Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello :
Please read this document, maybe help you.
http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year
Thanks for Reply I dont Want Hard coded I want as per user sel
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
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
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
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
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