Solved: how to create a group dynamically from editscript - Qlik Community

Report Inappropriate Content · ‎2011-05-20

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,,,,,

kaushiknsolanki · ‎2011-05-23

Hi,

Can you Please mark this post as answered.

Thanks,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

disqr_rm · ‎2011-05-20

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.

Report Inappropriate Content · ‎2011-05-21

hi ,

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

Thnks

Report Inappropriate Content · ‎2011-05-21

hi ,

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

Thnks

kaushiknsolanki · ‎2011-05-21

Hi,

Here is an example

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-05-21

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

Report Inappropriate Content · ‎2011-05-21

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

kaushiknsolanki · ‎2011-05-21

Hi

I am uploading an updated one.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-05-23

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.

kaushiknsolanki · ‎2011-05-23

Hi,

Here is your solition

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!