topic Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR in App Development

MASTER CALENDAR ROLLING FOR FISCAL YEAR

philgood34 — Thu, 31 Aug 2017 20:55:26 GMT

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

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

philgood34 — Fri, 01 Sep 2017 13:26:14 GMT

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

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

sunny_talwar — Fri, 01 Sep 2017 14:46:16 GMT

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?

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

philgood34 — Fri, 01 Sep 2017 14:56:08 GMT

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

sunny_talwar — Fri, 01 Sep 2017 15:01:03 GMT

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

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

philgood34 — Fri, 01 Sep 2017 15:19:19 GMT

don't see the attachment ?

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

sunny_talwar — Fri, 01 Sep 2017 15:20:16 GMT

Click here: Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

philgood34 — Fri, 01 Sep 2017 16:40:20 GMT

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

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

sunny_talwar — Fri, 01 Sep 2017 16:52:12 GMT

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

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

philgood34 — Fri, 01 Sep 2017 17:00:28 GMT

great !

maybe a variable in the script for the monthstart ?

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

sunny_talwar — Fri, 01 Sep 2017 17:11:11 GMT

Still not sure what you are looking to get?

Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR

philgood34 — Fri, 01 Sep 2017 18:26:03 GMT

imagine a sheet like this

in the perspective of spread my app to a lot of users through QLIK CLOUD HUB, it would be useful that each user could change his own settings without being obliged to change a script ..

of course, after using this sheet the first time, they don't use it anymore .... except if their fiscal year have to change ...

the only draw back is that the selections made will always appear above every others visualization sheets ...