topic Ho to create cyclic group using script in QlikView

Ho to create cyclic group using script

Wed, 07 Apr 2010 16:02:28 GMT

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.

Ho to create cyclic group using script

Wed, 07 Apr 2010 20:02:55 GMT

Hi Aldo:

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

Ho to create cyclic group using script

Wed, 07 Apr 2010 21:19:12 GMT

Hi there!

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

Ho to create cyclic group using script

boorgura — Wed, 07 Apr 2010 22:54:17 GMT

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

Its rather an innovative thought actually.

Ho to create cyclic group using script

Thu, 08 Apr 2010 00:48:50 GMT

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

Ho to create cyclic group using script

Thu, 08 Apr 2010 07:19:10 GMT

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.

Ho to create cyclic group using script

Thu, 08 Apr 2010 07:23:43 GMT

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';

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

Ho to create cyclic group using script

sparur — Thu, 08 Apr 2010 08:36:07 GMT

Hello Carlos.

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

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

Ho to create cyclic group using script

sparur — Thu, 08 Apr 2010 08:42:06 GMT

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.

Ho to create cyclic group using script

Thu, 08 Apr 2010 09:05:19 GMT

Nice!

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

Thanks,

Aldo.

Ho to create cyclic group using script

rwunderlich — Thu, 08 Apr 2010 09:07:30 GMT


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

You can assign expressions to variables like:
SET FinalAmount = sum((UnitPrice-Discount) * Quantity);

and then use the expression in a chart as:
=$(FinalAmount)

Is that what you are after?


Aldo wrote: 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".

QV Script provides a Switch Case statement. It's a control statement, so it cannot be used in a LOAD statement, which may be what you are looking for. There are alternatives to nested if(), such as mapping or the match() function. If you can post some specific examples of what you are dealing with, perhaps we can provide some suggestions.

-Rob

Ho to create cyclic group using script

sparur — Thu, 08 Apr 2010 09:18:02 GMT

Aldo, in standard Qlikview help you can find such description this function:

only( [{set_expression}] [ distinct ] [ total [<fld {, fld}>] ]expression)

If expression or field iterated over the chart dimension(s) contain one single value, that value is returned, else NULL is returned. Only can return numeric values as well as text values.

Ho to create cyclic group using script

Thu, 08 Apr 2010 10:37:31 GMT

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.02.89.41/Test_2D00_Creating-Group-Sample-20100408000.qvw]

Guys,

I try Anatoly's approach, but something is missing.

Please take a look at the attachment.

Actually, I need to make the Table showing the sales by Db or Company or Division.

Rob, I am using your suggestions.

Thanks in advance for any help.

Aldo.

Ho to create cyclic group using script

sparur — Thu, 08 Apr 2010 10:51:07 GMT

Aldo, I fixed your example.

see in attachment.

Ho to create cyclic group using script

Thu, 08 Apr 2010 11:57:24 GMT

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.02.89.41/Test_2D00_Creating-Group-Sample-20100408001.qvw]

GREAT!

Thanks a lot!

Could you help me fixing the SET statement (in script) for variable "vdbOrCompOrDiv" in order to make Table2 working?

Take a look in the attached file.

Thanks again.

Aldo.

Ho to create cyclic group using script

sparur — Thu, 08 Apr 2010 12:07:59 GMT

Aldo, what do tou want to achieve in table2?

Ho to create cyclic group using script

sparur — Thu, 08 Apr 2010 12:10:52 GMT

Aldo, What do you want to achieve in table2?

Ho to create cyclic group using script

Thu, 08 Apr 2010 12:19:50 GMT

The same thing as the first table, but creating the variable in the script, instead of typing

=CHR(91) & $(vCurField) & chr(93)

in the dimensions of the table.

Thanks,

Aldo.

Ho to create cyclic group using script

sparur — Thu, 08 Apr 2010 13:03:39 GMT

see in attachment

Ho to create cyclic group using script

Thu, 08 Apr 2010 13:45:59 GMT

Fantastic!

Thanks again,

Aldo.