topic Help: Load script in QlikView

Help: Load script

Tue, 01 May 2012 03:12:01 GMT

Hi All,

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

I attached a sample qvw file for your reference.

Thank you!

Help: Load script

Tue, 01 May 2012 06:18:03 GMT

any idea?

please help..

Help: Load script

Tue, 01 May 2012 07:30:25 GMT

I'm not sure I follow what your issue is, can you give me some more info as to what you're trying to achieve?

Help: Load script

Tue, 01 May 2012 07:40:15 GMT

I have four fields in which i want to consolidate into a single field but that single field is arrange based on the order of each fields.

for example

Level1 Field

Level2 Field

Level3 Field

Level1 Field

Level2 Field

Level3 Field

Help: Load script

Tue, 01 May 2012 07:52:06 GMT

Maybe I'm still not getting it but can you not just amend your initial laod to concatenate the fields into one (I've not catered for if the fields are nullable)

FinalPandLTable:

LOAD Account,

DateKey,

[Detailed Account Mapping],

[Account Groupings],

[P&L Groupings],

[Major P&L Groupings],

[Major P&L Groupings Seq],

[P&L Groupings Seq],

[Account Groupings Seq],

[Detailed Account Mapping Seq],

[Major P&L Groupings]+[P&L Groupings]+[Account Groupings]+[Detailed Account Mapping] as GroupedField

FROM

FinalPandLTable.qvd

(qvd);

Help: Load script

Tue, 01 May 2012 07:56:35 GMT

if i concatenate the fields it will not give me the result that i want .

I want to have that in a single field so that i can use it in a pivot table.

have you seen the summary table in the script window?

Help: Load script

Tue, 01 May 2012 08:06:56 GMT

Oh I think I'm understanding what you're getting at, you want to be able to select in the same field - can you group the fields so that you can select which level to pick and then pick within the level?

Help: Load script

qlikviewajeet — Wed, 02 May 2012 05:24:02 GMT

Hi Mars

did that query solve ur problem?

Note: by that solution u can select all ur required dimensions individualy or togather in one field.

u welcome for next.

Help: Load script

Fri, 04 May 2012 06:02:08 GMT

No sir,

Re: Help: Load script

qlikviewajeet — Mon, 07 May 2012 06:09:32 GMT

Hi,

Right click on sheet - select multibox - add dimensions - apply - OK

by this solution a multibox is created and u can find all selected fields in one box.

plz find attachment

is this not your solution, Mars?

with regards

Ajeet singh

Help: Load script

subin6600 — Mon, 07 May 2012 11:21:54 GMT

Hi Mars,

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

Regards,

Subin

Re: Help: Load script

jonathandienst — Mon, 07 May 2012 11:32:00 GMT

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

Help: Load script

subin6600 — Mon, 07 May 2012 11:44:18 GMT

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!

Re: Help: Load script

vincent_ardiet — Mon, 07 May 2012 11:46:13 GMT

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

Re: Help: Load script

jonathandienst — Mon, 07 May 2012 11:57:28 GMT

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

Help: Load script

jonathandienst — Mon, 07 May 2012 11:59:19 GMT

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

Jonathan

Help: Load script

Tue, 08 May 2012 00:25:47 GMT

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?

Re: Help: Load script

qlikviewajeet — Wed, 09 May 2012 11:43:04 GMT

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

Re: Help: Load script

Wed, 09 May 2012 23:37:05 GMT

hi sir,

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

Help: Load script

qlikviewajeet — Thu, 10 May 2012 04:01:36 GMT

are other 4 fields are diensions or expressions?

plz attached your application document for better understanding,