Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
hi everybody
i found a thread (qlikview) about my issue,
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
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?
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
You probably don't need two calendars... can rerun the app that I attached?
don't see the attachment ?
Click here: Re: MASTER CALENDAR ROLLING FOR FISCAL YEAR
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
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
great !
maybe a variable in the script for the monthstart ?