Ho to create cyclic group using script

[#1]

Hi guys,

Is there any way to create a cyclic group in the script instead of defining it in document properties?

Thanks in advance,

Aldo.

[#2]

Hi Aldo:

I think that is not possible, what problem do you have if you cre<te the ciclic group in the chart??

[#3]

Hi there!

Its not a must, but I think it will be "cleaner" creating the group in the script.

[boorgura]

I doubt if there is a way to create a group (cyclic/drill) in the script itself.

Its rather an innovative thought actually.

[#5]

Maybe if in the script you create a variable and the you do this:

variable = case (x = 1) Field A

case X = 2 Field B

And then in the chart you manipulate the X with a button or something like that, maybe it can be possible that way

[#6]

I'd like to be able to create & manage all my variables and groups in the code itself. That will make my script being stronger & cleaner. In addition It will allow me to "re-work" the GUI faster.

I successfully created some variables, but I can not create variables where I need to calculate Sums, etc...

I also want to know if there is any statement (in qlikview script) to be used like "Switch" or "Select Case" instead of dealing with a lot of "Ifs".

Thanks in advance,

Aldo.

[#7]

In order to create something to simulate a group, I tried to do something like the script below, but it did not work.

//Groups.

CompanyOrDivision:

LOAD * INLINE [

Selection, CompanyOrDivision

Db, DB

Company, CompanyName

Division, Division

];

//Variables:

SET vCompanyOrDivision = '=CompanyOrDivision';

//--------------------------------------------

[sparur]

Hello Carlos.

Can you post some work script, which used your solution.

Because I don't understand how I can apply suggested approach.

[sparur]

Hello Aldo.

If you want change field in expression by your selection in other field I can provide you some approach which I use often.

see in attachment.

[#10]

Nice!

I don't understand what is the "Only()" for. Could you explain?

Thanks,

Aldo.