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
Not applicable
Author

any idea?

please help..

Not applicable
Author

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?

Not applicable
Author

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

Level2 Field

Level3 Field

Level1 Field

Level2 Field

Level3 Field

Not applicable
Author

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);

Not applicable
Author

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?

Not applicable
Author

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?

qlikviewajeet
Contributor III
Contributor III

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.

Not applicable
Author

No sir,

qlikviewajeet
Contributor III
Contributor III

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