Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
philgood34
Contributor II

MASTER CALENDAR ROLLING FOR FISCAL YEAR

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

1 Solution

Accepted Solutions

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

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

Capture.PNG

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

11 Replies
philgood34
Contributor II

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

hi everybody

i found a thread (qlikview) about my issue,

Fiscal Year

with this script

FISCAL.png

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

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

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
Contributor II

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

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

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

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

philgood34
Contributor II

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

don't see the attachment ?

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

philgood34
Contributor II

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

wonderful  !

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

FISCAL3.png

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

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

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

Capture.PNG

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
Contributor II

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

great !

maybe a variable in the script for the monthstart ?

Community Browser