topic Re: how to create a group dynamically from editscript in QlikView

how to create a group dynamically from editscript

Fri, 20 May 2011 15:54:45 GMT

Hi,

I have a table in the editscript that is generated from the qvdfile. that table like(Test) Has 3 columns with 10 rows of data.I have loaded that table in to the qlikview. From the frontend i have created a group with those table columns.Right now this is good .But in future the data may increases for those table(like new columns may be added).But my group doesn't have the updated values.So,what my requirement is how to update the group automatically from the editscript.

Is it possible to update my group from the editscript....

Please share your valuable information with your replies to me and this is an urgent requirement.

Thanks in advance,,,,,

how to create a group dynamically from editscript

disqr_rm — Fri, 20 May 2011 21:53:12 GMT

Pretty sure not possible in QV Script, but you can build something using macro (using VB Script). Look into API Guide for following:

groups=ActiveDocument.GetGroups

groups(0).AddField = "City"

Similar to AddField, there is removefield and other methods are available. You can, on OnOpen or at some event, remove all the fields of a group and add all of them back from a table. You can surely get table fields in the VBScript and loop through values and add all of them back in.

Hope this helps.

how to create a group dynamically from editscript

Sat, 21 May 2011 11:12:28 GMT

hi ,

can you provide sample qlikview file with attaching the macro which you shown.

Thnks

Re: how to create a group dynamically from editscript

Sat, 21 May 2011 11:13:32 GMT

hi ,

can you provide sample qlikview file with attaching the macro which you shown.

Thnks

Re: how to create a group dynamically from editscript

kaushiknsolanki — Sat, 21 May 2011 11:23:42 GMT

Hi,

Here is an example

Regards,

Kaushik Solanki

Re: how to create a group dynamically from editscript

Sat, 21 May 2011 14:12:25 GMT

Hi Kaushik,

Thanks for your post, you are getting very near to my requirement.

But actually in your listbox having the customer , product, Orderid.

Instead of going with ctl+m and changing the name, i need to have when i click your list box fields that selected fileds should be grouped..

I hope you can provide a solution on this.

Thnks a lot behalf of your post in advance

Re: how to create a group dynamically from editscript

Sat, 21 May 2011 14:12:45 GMT

Hi Kaushik,

Thanks for your post, you are getting very near to my requirement.

But actually in your listbox having the customer , product, Orderid.

Instead of going with ctl+m and changing the name, i need to have when i click your list box fields that selected fileds should be grouped..

I hope you can provide a solution on this.

Thnks a lot behalf of your post in advance

Re: how to create a group dynamically from editscript

kaushiknsolanki — Sat, 21 May 2011 17:04:15 GMT

I am uploading an updated one.

Regards,

Kaushik Solanki

Re: how to create a group dynamically from editscript

Mon, 23 May 2011 05:28:24 GMT

HI,

The attachement of your post is awesome, but if i am selecting the multiple selection in the listbox and click on the add_group button , it is adding the only one into group.

Can i add into group with multi selections.

Is it possible to do that. If yes, pls send me attached file.

Thnks in advance.

Re: how to create a group dynamically from editscript

kaushiknsolanki — Mon, 23 May 2011 06:10:26 GMT

Hi,

Here is your solition

Regards,

Kaushik Solanki

Re: how to create a group dynamically from editscript

Mon, 23 May 2011 06:23:07 GMT

Hi Kaushik,

Thanks for your reply,

I am not able to open what you attached file in my system. Please can you send the button script in text format.

Thanks...

Re: how to create a group dynamically from editscript

Mon, 23 May 2011 06:23:35 GMT

Hi Kaushik,

Thanks for your reply,

I am not able to open what you attached file in my system. Please can you send the button script in text format.

Thanks...

Re: how to create a group dynamically from editscript

kaushiknsolanki — Mon, 23 May 2011 07:37:35 GMT

Hi,

Here is the script

sub add_Group
''groups=ActiveDocument.GetGroups
''groups(0).AddField "OrderID"
counter = 0
set LB = ActiveDocument.GetSheetObject("LB01")
boxvalues=LB.GetPossibleValues
for i = lbound(boxvalues) to ubound(boxvalues)
count = count + 1
next
if count = LB.GetRowCount then
msgbox "Please select one dimension"
Exit sub
else
    'field = boxvalues(0)
    for i = lbound(boxvalues) to ubound(boxvalues)
field = boxvalues(i)
call Add_grp(field)
next
end if

end sub

sub Add_grp(field)
set group = ActiveDocument.GetGroup("New Group")
set gp = group.GetProperties
set vars = gp.FieldDefs
for i = 0 to vars.Count-1
    set fld = vars(i)
    'msgbox("field " & i+1 & " is " & fld.Name)
    if field = fld.name then
     counter = 1
    end if
next

if counter = 0 then
group.AddField field
msgbox field &" is Added to Group"
end if
end sub
''set group = ActiveDocument.GetGroup("New Group")
''set gp = group.GetProperties
''msgbox(gp.Present)

Regards,

Kaushik Solanki

Re: how to create a group dynamically from editscript

Mon, 23 May 2011 08:25:45 GMT

Hi Kaushik,

Thanks a lot for sending the post and i got absolutely what i am looking for...

Thank you very much

Re: how to create a group dynamically from editscript

kaushiknsolanki — Mon, 23 May 2011 08:29:59 GMT

Hi,

Can you Please mark this post as answered.

Thanks,

Kaushik Solanki

Re: how to create a group dynamically from editscript

Mon, 23 May 2011 08:45:45 GMT

hi Kaushik,

Thanks for your reply,

Your code is working well.

i want another small task for that . That is how to remove the selected barchart field from the group, and this is to be done by using another button.

Please send the solution for that by text format.

Thanks....

Re: how to create a group dynamically from editscript

kaushiknsolanki — Mon, 23 May 2011 09:43:55 GMT

Hi,

Here is your answer

end sub

sub Remove_Group
''groups=ActiveDocument.GetGroups
''groups(0).AddField "OrderID"
counter = 0
set LB = ActiveDocument.GetSheetObject("LB01")
boxvalues=LB.GetPossibleValues
for i = lbound(boxvalues) to ubound(boxvalues)
count = count + 1
next
if count = LB.GetRowCount then
msgbox "Please select one dimension"
Exit sub
else
    'field = boxvalues(0)
    for i = lbound(boxvalues) to ubound(boxvalues)
field = boxvalues(i)
call Remove_grp(field)
next
end if

end sub

if counter = 0 then
group.AddField field
msgbox field &" is Added to Group"
counter = 1
end if
end sub
''set group = ActiveDocument.GetGroup("New Group")
''set gp = group.GetProperties
''msgbox(gp.Present)

sub Remove_grp(field)
set group1 = ActiveDocument.GetGroup("New Group")
set gp = group1.GetProperties
set vars = gp.FieldDefs
for i = 0 to vars.Count-1
    set fld = vars(i)
    'msgbox("field " & i+1 & " is " & fld.Name)
    if field = fld.name then
     group1.RemoveField i
     msgbox field &" is Removed From Group"
     exit sub
    else
     counter1 = 0
    end if
next

if counter1 =0 then
msgbox field & "is not in group"
counter1 =1
end if
end sub

Regards,

Kaushik Solanki

Re: how to create a group dynamically from editscript

Mon, 23 May 2011 12:57:44 GMT

Hi Kaushik,

What you sent the code for removing the fields from the group is not working.

can you tell me how to remove the field from the group in a step by step procedure.

Thanks.

Re: how to create a group dynamically from editscript

kaushiknsolanki — Mon, 23 May 2011 17:57:46 GMT

Hi,

Its working fine my side.

Can you tell me what happens, are you getting any errors

Regards,

Kaushik Solanki

Re: how to create a group dynamically from editscript

Tue, 24 May 2011 05:10:21 GMT

Hi Kaushik,

First of all i really thank you for giving immediate response to us...

i am able to select the fields from listbox and when i click on the button, the fields are adding into the group.

But how can i remove the fields from group. Whether i need to click on the listbox and select a field and then i need to click on the button.

I had approached in two ways for removing the field from group.

1.) After adding all the fields in listbox to a Group, then i am again selecting the field from listbox and then i am clicking on the button, but it is not removing the fields and also not showing any errors.

2.)In the same way, my output is shown in barchart, that barchart contains group dimension. So when i click particular field from group in barchart and then again i clicked on the button. In this way also not removing the field and not showing any error.

Pls can you tell in process i need to remove the fields from group. And i had a question on this, Whether i need to add all the fields in listbox into group and after that only can i remove???

I am sure that you understand my problem.

Thnks