topic TreeView Display in QlikView

TreeView Display

jagannalla — Fri, 27 May 2011 06:54:47 GMT

Hi,

- I want to display in sheet in treeview format. I've a 5 groups for each group there is a different FieldNames.

- If i select 1 group i want to display FieldNames of particular group only viceversa for all groups.

Eg:

Group:

- Now I'll select 'A' in group den i want to display FieldNames of A in list box Otherwise if i select 'B' den i want to display FieldNames of B in another list box.

TreeView Display

kaushiknsolanki — Fri, 27 May 2011 07:39:50 GMT

Hi,

Can you please tell me by what way you will be selecting the group.

As far as i know its not possible to table the group names in list box.

Regards,

Kaushik Solanki

TreeView Display

jagannalla — Fri, 27 May 2011 10:34:22 GMT

Group is a listbox.A,B,C,D,E are another listboxes

TreeView Display

kaushiknsolanki — Fri, 27 May 2011 10:39:01 GMT

Hi,

Can you please upload the QVW for more clearification

Regards,

Kaushik Solanki

TreeView Display

IAMDV — Fri, 27 May 2011 10:40:21 GMT

jagannalla - Please can you load a QV document with sample data? I can give a try for sure. Also it would be great if you can explain in more detail.

Cheers - DV

Re: TreeView Display

jagannalla — Fri, 27 May 2011 10:56:00 GMT

I attached qvw file. If possible can you see the problem of following link it is related to this problem also.

http://community.qlik.com/message/119925#119925

Re: TreeView Display

jagannalla — Fri, 27 May 2011 10:56:32 GMT

I attached qvw file. If possible can you see the problem of following link it is related to this problem also.

http://community.qlik.com/message/119925#119925

Re: TreeView Display

IAMDV — Fri, 27 May 2011 11:52:01 GMT

Jagannalla - Here is the QV find attached. I had used the conditional show/hide expression to show and hide the listboxes. And you need to use this expression...

Listbox A = findoneof( GetFieldSelections(Group) , 'A') <> 0

Listbox B = findoneof( GetFieldSelections(Group) , 'B') <> 0

Apply the same logic for all the objects. I am also attaching the QV document.

Please let me know if you need more explanation

Cheers - DV

Re: TreeView Display

jagannalla — Fri, 27 May 2011 12:51:20 GMT

Hi DV,

- U r code is good. But how can i keep in order of listbox. i.e based on selection in group.

- So that i can remove the space.

I've seen the minimize and maximize functionalilty with charts in " Manufacturing Demo" qvw ( "Completed Cost" sheet) file that kept in qlikview community.

But i don't know how it is working can you see once and explain me how it is working. I'm attaching that file also.

Re: TreeView Display

IAMDV — Fri, 27 May 2011 14:32:21 GMT

Jagannalla - I am looking into the Macnfacturing Demo. Meanwhile let me understand what you want fully... Do you want to change the position of the objects based on selection? I mean if you select A,C,E in the Group Listbox... Do you want see A,C,E Listboxes in order rather than being random?

Cheers - DV

Re: TreeView Display

IAMDV — Fri, 27 May 2011 14:39:57 GMT

I had looked into the example and I am not sure if you are referring to chart objects, where if you select one chart the other chart minimizes. If this is what you are looking then you need enable Auto Minimize option under "Caption" tab.

I am also attaching a screenshot for your reference. Let me know if you need something else.

Cheers - DV

Re: TreeView Display

jagannalla — Sun, 29 May 2011 05:56:53 GMT

D V - Yes, I want to change the position of objects based on seleciton. I mean if you select A,C,E in the Group Listbox...I want see A,C,E Listboxes in order rather than being random.

- What you understand is correct D V.

Re: TreeView Display

IAMDV — Sun, 29 May 2011 10:15:21 GMT

Jagannalla - I think you need to use VB Script to get this working. I mean you can't control the obj positioning through expression. However, you can control the positioning through the VB Script. So the idea is to use the logic I gave earlier to activate the objects based the "Group" CheckBox and then you need to get the macro working to position the objects. Here is the sample code to move all the objects on the Sheet. Please edit this code and build a logic around the specific ListBoxes.

Sub ActiveObj_Postioning

Set sh = ActiveDocument.ActiveSheet

For i = 0 to sh.NoOfSheetObjects-1

set obj = sh.SheetObjects(i)

set fr = obj.GetFrameDef

pos = fr.Rect

pos.Top = pos.Top + 60

pos.Left = pos.Left + 45

obj.SetFrameDef fr

End Sub

Good luck!

Cheers - DV

Re: TreeView Display

jagannalla — Wed, 01 Jun 2011 08:23:59 GMT

D V,

Once again thanks a lot for your macro. But in which action i need to keep this macro. Can you help me little bit more.