Open document on current fiscal year and previous ... - Qlik Community

Anonymous · ‎2017-09-25

Our fiscal calendar is defined as fiscal year and week. I am trying to open a document which would by default select the fiscal year we are in and the previous fiscal week.

Please see attached sample file with the calendar loaded. The calendar is generated using QVD from another application that I can't really access or modify.

How can I achieve the above? Please advise.

Thanks,

Amit

Anil_Babu_Samineni · ‎2017-09-25

Your condition works well as expected. for 2017, You have 53 weeks which means before week should be 52 only. you are not expecting that then what is the expected logic value to pick the 51?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-09-26

No it just giving me 1 week before the max FISCAL_WEEK. I need to give me the previous FISCAL_WEEK based on the current date (today).

Open document on current fiscal year and previous fiscal week