topic Re: Fiscal Year in QlikView

Fiscal Year

ramcena306 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

In my project the fiscal year start from October, so in the chart I have to show if the month is October then is should show previous fiscalyear data(oct 2017 to nov 2018).

something like--if (FISCAL YEAR+1)= Previous Year Data.

Please Help Me.

marcus_sommer‌kaushik.solanki ‌chakshujain29 ‌radoresky ‌jimhalpert ‌nick2009 ‌stalwar1 ‌

devarasu07‌

Regards,

Ram.

Re: Fiscal Year

marcus_sommer — Tue, 09 Oct 2018 06:57:59 GMT

Take a look here: Fiscal Year

- Marcus

Re: Fiscal Year

ramcena306 — Tue, 09 Oct 2018 07:16:31 GMT

Hello Marcus,

I want to do it in frontend. Any Suggestions?

Ram

Re: Fiscal Year

marcus_sommer — Tue, 09 Oct 2018 07:29:42 GMT

A frontend solution could be very expensive because you would need to add these (not simple) matchings and calculations to each expression/object which should cover this functionality and it could decrease the performance quite heavily - therefore the clear suggestion: do it within the datamodel and not within the UI.

- Marcus