Discussion Board for collaboration related to QlikView App Development.
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
Thanks in advanace
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
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.
Please give solution.
In the first answer I wrote you a link to a Technical Brief about deploying Fiscal Year.
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