Group with Load Inline

[Anonymous]

Hello everyone,

I'm new to QlikView and I would like my group several more lines in a table, and was advised to go through a Load * Inline.

Here is my table in Access:

Here is my code in QlikView:

Load * inline
[
Job_Titles,Job_Titles_grp
Sales,Sales
Trader,Trader
Index Designer,Index Designer
Struturers,Struturers
Quant, Mgt & Sup. Fonctions
Direction, Mgt & Sup. Fonctions
Scrétaire, Mgt & Sup. Fonctions
CNSE Trainee,CNSE Trainee
EXECBROKER,EXECBROKER
];

Knowing that I would group Quant, Direction and Secretary in Mgt & Sup. Function and add associated values presented in the table Résultats.

Thanks in advance !

Cocalero.

[swuehl]

Sorry, I think I missed your question here, could you please detail the problems you have?

[Anonymous]

Hello,

I want to regroup several Job_Titles (such as Quant, Support and Secretaire) into one group named Mgt. and support for example, and i try to use a Load inline for that into Qlikview however just the first Job, here Quant, is renamed as Mgt. and support.

How can i regroup these jobs and sum the table Val associated to them ?

Thank you in advance,

Cocalero.

[swuehl]

Not sure why this shouldn't work. If you load your original table and your inline table, both tables should be linked by Job_Titles field. You essentially are not renaming field values, but you are creating a new field with the group values, so both the grouped and the detailed job titles should still be available.

So if you create a chart with dimension Job _Titles_grp and Sum(Val) as expression, you should get your values grouped as requested (you can add a second dim Job_Titles to the chart to verify the grouping).

Could you post more details about your data model and your chart settings, maybe best by posting a small sample QVW.

[puttemans]

Hello Sébastien,

You need to make a link between your inline load, and your loaded table. Guess the best thing to do, is make a mapping load out of your inline load.

Map_types:

Mapping load * Inline....(the rest is ok as in your post above)

Then you load the access table, and you add in the load

Applymap('Map_types', Job_Titles, '-') as Newjobgroup,

By doing so, you keep your original variable, and you create a new one. Now, if you sum on 'Newjobgroup', I think you have what you're looking for.

Best regards,

Johan