Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help: Load script

Hi All,

I have four fields that i want to group as 1 field but can't find the solution. see attached image forums.JPG

I attached a sample qvw file for your reference.

Thank you!

23 Replies
subin6600
Creator III
Creator III

Hi Mars,

According to the screenshot attached  I don't think so we can implement such style in Qlikview.

Regards,

Subin

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Do you mean that you want to display the data as a tree view as shown in your image?

You can do that by creating a concatenate field from the 4 fields with a separator character (usually /, but can be other if required). Create a list box for this field, and then in the list box Properties | General, check 'Show as TreeView' and enter the separator character that you used.

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
subin6600
Creator III
Creator III

Hi Jonathan,

Yes it really works. Just that we need to manually expand each of the field. Do you have any settings for always making it expanded as we have for the pivot table. Thanks!

vincent_ardiet
Specialist
Specialist

Hi,

Try like this:

Add to your table FinalPandLTable a new field based on the following formula :

[Major P&L Groupings]&'/'&[P&L Groupings]&'/'&[Account Groupings]&'/'&[Detailed Account Mapping]

Then create a listbox with this field and check the "Show as Tree view" option.

Regards,

Vincent

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Regrettably, I don't think it is possible to make it fully expanded. Perhaps there's a macro guru who could figure out how to do it in the API, but I suspect not.

What about using a pivot table and making the selections in there? You can make a pivot table with the 4 fields as dimensions and no expressions, and clear the supress zero and suppress missing options (I think that worked in QV9 )

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst
Partner - Champion III
Partner - Champion III

The downside of using a pivot is that you cannot make multiple selections.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

what i want to achieve is to have that the same look in the listbox in the pivot table, where in the values are grouped based on their parent value. those values are in one column in the pivot table. is this possible? if not, is it possible to export the pivot table in excel and have those four columns in one column in excel?

qlikviewajeet
Contributor III
Contributor III

Hi right click on Pivot table-Properties - in Presentation Tab - select always fully expanded.

Not applicable
Author

hi sir,

even if i activate that setting, still the 4 fields are on different columns

qlikviewajeet
Contributor III
Contributor III

are other 4 fields are diensions or expressions?

plz attached your application document for better understanding,