topic Re: Set Variables in QlikView

Set Variables

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the following calendar script:

I then use the PeriodID, MonthID and QuarterID to create set variables for year to date, month to date etc as per the attached script. I have added a fiscal calendar to the Master Calendar and now want to adjust the attached set variables to do the year to date, month to date etc using the fiscal dates. How can this be accomplished?

Regards

Re: Set Variables

santiago_respane — Fri, 29 Apr 2016 12:59:20 GMT

Hi Christopher,

where are you using those expressions?

Are you using set analysis in the loading script?

Please elaborate more in order to be able to help you!

Kind regards,

Re: Set Variables

jonathandienst — Fri, 29 Apr 2016 13:09:45 GMT

Just create 3 more fields in the topmost LOAD step using the fiscal year, quarter, month and week fields from preceding load step using the same logic as the existing calendar ID's.

Re: Set Variables

Anonymous — Fri, 29 Apr 2016 15:02:03 GMT

Many thanks Santiago

I load the script at the back end of the app as below and use set analysis on the front end with the loaded variables as follows:

Re: Set Variables

Anonymous — Fri, 29 Apr 2016 15:03:37 GMT

Thanks Jonathan

I have done it as follows:

I am not quite sure how to approach it for the fiscal year, i.e. generate the PeriodID for the fiscal year

Regards.