Sum quantity on two dimension

[PAD]

 Hi,

I am trying to sum quantity by name and by year.

But into the graph, each bar contains all the quantity and not just the quantity matching this name.

How can I setup my dimensions and mesure ?

I don't find documentation about that.

[RafaelBarrios]

Hi @PAD 

it seems to me that your name field "nom" could be in a table that is separated from the rest of the data model or its not well related.

can you paste your data model?

Best,

help users find answers! Don't forget to mark a solutions that worked for you & to smash the like button!  😁

[PAD]

Hi,

thanks for your respond.

I have 2 tables (I am just making test with only 2 tables to understand how it works) :

command and partner.

The field nom (name) come from partner, and qte (quantity) come from command.

I link them together :

But into the data model, they don't seems to be link :

[RafaelBarrios · Accepted solution]

now i see the problem.

you need your two table to be connected by just one field, Qlik will do this when fields in two tables has the same name

yo can do this in script by usign an alias in a field

or, if you are using the data manager, by connecting bubbles and selecting the link fields

hope this helps.

help users find answers! Don't forget to mark a solutions that worked for you & to smash the like button!  

[PAD]

What if my two tables don't have the same field name (they both have an id field, but i don't want them to link on the id field, I want to match id from partner with partner_id into command)

[PAD]

Ok, I manage to do it with the data manager.

After creation of the link into the data manager, you have to press the load button in the upper right.

Thanks for your help 🙂

[RafaelBarrios]

then as i paste in the second image

if you are using script

parner_table:
load
id as parner_id,
...
...
...
FROM ....;

command_table:
load
parner_id,
...,
...,
...
FROM ....;

hope this helps,

help users find answers! Don't forget to mark a solutions that worked for you & to smash the like button!