topic Pre-Define Dimesion Group Settings within Load Script? in QlikView

Pre-Define Dimesion Group Settings within Load Script?

Fri, 15 Jul 2016 07:34:04 GMT

Hi Qlikkies,

Just a general inquiry from my side.

Is it possible to Pre-Define Dimesion Group Settings within Load Script?

To illustrate:

We have an IF statement in the load script defining alot of settings based on different initial values.

We have 2 entities with different Year measurements one being a calendar year and the other financial year for example.

We use this as a "Time" group in a dimension.

Therefore:

IF '$(vName)' = 'pse' THEN
let vFolderSourceData = 'C:\QlikView\Data FilesPSEMAS\';
let vStartPer = '01/04/2012';
let vStart = '201204';
let vEndPer = '30/06/2016';
let vEnd = '201606';
let vSchemePeriod = '0006201204';
let vCalendarYear = '=FinYearPsemas' ;
ELSE
let vFolderSourceData = 'C:\QlikView\Data Files\';
let vStartPer = '01/01/2012';
let vStart = '201201';
let vEndPer = '30/06/2016';
let vEnd = '201606';
let vSchemePeriod = '0001201201';
let vCalendarYear = '=Year' ;
END IF

============================================================================================

So what i want to know is how to in the script above achieve the changes shown below:

IF '$(vName)' = 'pse' THEN

ELSE

END IF

Your soonest replies would be greatly appreciated.

Thank you!

Re: Pre-Define Dimesion Group Settings within Load Script?

tresB — Fri, 15 Jul 2016 07:47:27 GMT

Not sure if understood right. You may create two groups like time1 and time2 and then while use then in chart, use conditional dimension like:

Re: Pre-Define Dimesion Group Settings within Load Script?

Gysbert_Wassenaar — Fri, 15 Jul 2016 07:59:21 GMT

Is it possible to Pre-Define Dimesion Group Settings within Load Script?

No, but you can use expressions to create calculated dimensions to use in your group.

Re: Pre-Define Dimesion Group Settings within Load Script?

Fri, 15 Jul 2016 08:47:06 GMT

Thank you gentleman for your replies. Found it most enlightening.

Now 1 more question on a similar basis.

Would it be possible either in load script or in conditional (Though in a list box i dont see a conditional) to pre-define The FIELD Namely in below FinYearPsemas :

To change based on the 'pse' variable in previous post to the below specifically on a list box object:

Your insights are welcome.

Regards,

Heinrich

Re: Pre-Define Dimesion Group Settings within Load Script?

tresB — Fri, 15 Jul 2016 09:05:09 GMT

Click on the 'expression' from the drop-down and write your expression there like:

=If (vName='pse', FinYearPsemas, Year)

Re: Pre-Define Dimesion Group Settings within Load Script?

Fri, 15 Jul 2016 09:23:35 GMT

Your experience is well appreciated.

Re: Pre-Define Dimesion Group Settings within Load Script?

oknotsen — Fri, 15 Jul 2016 09:58:22 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .