topic Re: Group with Load Inline in QlikView

Group with Load Inline

Anonymous — Mon, 29 Feb 2016 15:09:05 GMT

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.

Re: Group with Load Inline

swuehl — Mon, 29 Feb 2016 18:37:12 GMT

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

Re: Group with Load Inline

Anonymous — Tue, 01 Mar 2016 09:26:08 GMT

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.

Re: Group with Load Inline

swuehl — Tue, 01 Mar 2016 12:13:41 GMT

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.

Re: Group with Load Inline

puttemans — Tue, 01 Mar 2016 12:23:08 GMT

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