MASTER CALENDAR ROLLING FOR FISCAL YEAR

[philgood34]

i saw lot of threads about that popular issue in qlikview community

my particular issue is about QLIK SENSE

i already have my script with MASTER CALENDAR in my QLIK SENSE app.

now for my visualizations i need  set analysis on fiscal year (starting in April for exemple)

is the solution is to :

          add anything in loading script ?

          Insert particular expression in fields of my visualization ?

          create a selector with the possibilty to select a dimension as fiscal year?

sorry for that poor issue, but i didn't find any reponse for the moment (or rather a lot of reponses that have lost me 😞

i join an app to make the reponse easier with a example

regards

Philippe

[philgood34]

hi everybody

i found a thread (qlikview) about my issue,

Fiscal Year

with this script

i pasted it after mine (with master calendar). as you can see in my joined app

i obtained no result in the visualization ?

Anybody  to help me to insert this script correctly please ?

I confess i don't unterstand how make my master calendar and this fiscal calendar compatible ...

HELP !

regards

[sunny_talwar]

What are you hoping to do with this fiscal calendar? I guess what changes are you hoping to see on the front end? Can you reload the attached app and attach it back here?

[philgood34]

here is it

well, i hope to be able to analyse performances alternately on the fiscal or usual year.

for the moment i don't create others visualizations  because as you will see , when i select de Fiscal year, no values appear on the graph, and the selection APRIL to MARCH that i hope on the graph don't work

regards

[sunny_talwar]

You probably don't need two calendars... can rerun the app that I attached?

[philgood34]

don't see the attachment ?

[sunny_talwar]

Click here: Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

[philgood34]

wonderful  !

only 3  lines added and the light arises :-))

after all the scripts i tried without realy understanding, your reponse is a comfort !

is there any tip to have the name like 2016_2017 instead of 2016 to differenciate with the usual year ?

and, is it possible to be able  for the user to parametrer the start month in a sheet with a selector ? i would be the top !

regards

Philippe

[sunny_talwar · Accepted solution]

You can use 2016-2017 by adding a preceding load like this

and, is it possible to be able  for the user to parametrer the start month in a sheet with a selector ? i would be the top !

Not sure I understand this

[philgood34]

great !

maybe a variable in the script for the monthstart ?