Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ramcena306
Creator
Creator

Fiscal Year

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.solankichakshujain29radoreskyjimhalpertnick2009stalwar1

devarasu07

Regards,

Ram.

3 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

Take a look here: Fiscal Year

- Marcus

ramcena306
Creator
Creator
Author

Hello Marcus,

I want to do it in frontend. Any Suggestions?

Ram

marcus_sommer
MVP & Luminary
MVP & Luminary

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