Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Aldo:
I think that is not possible, what problem do you have if you cre<te the ciclic group in the chart??
Hi there!
Its not a must, but I think it will be "cleaner" creating the group in the script.
I doubt if there is a way to create a group (cyclic/drill) in the script itself.
Its rather an innovative thought actually.
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
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.
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';
//--------------------------------------------
Hello Carlos.
Can you post some work script, which used your solution.
Because I don't understand how I can apply suggested approach.
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.
Nice!
I don't understand what is the "Only()" for. Could you explain?
Thanks,
Aldo.