Can't compare different company sales.

[Jwillmann]

Hello Community,

I have a table that looks like this

customer	company1	company2	company3
customer1	cus1salesc1	cus2salesc2	cus3salesc3
customer2	cus2salesc1	cus2salesc2	cus2salesc3

with many more customers and a few more companies.

I added a column at the end which adds the sales of all companies for one customer.

now i want a piechart which compares the sales of company1 to all customers, to the sales of company2 to all customers etc.

But i can't pick a dimension that makes sense for me. Neither for a barchart. I think it should be the sum(of the added summary column) but i can't put that formula in the dimension.

Thank you for the help

[JordyWegman]

Hi Willmann,

You need to change the structure of your data. You know how to?

Put it like this and it will work:

Customer	Company	Sales
1	1	cus1salesc1
2	1	cus2salesc1
1	2	cus2salesc2
2	2	cus2salesc2
1	3	cus3salesc3
2	3	cus2salesc3

Jordy

Climber

[Jwillmann]

Hi thanks for the answer and help, if there is a quick way in qlik i don't know how to do that yet.

Willmann

[JordyWegman · Accepted solution]

Hi,

Yes there is, watch this video of Qlik on how to do that in your Data Manager: https://www.youtube.com/watch?v=R_d2pk1DjzU

Jordy

Climber

[Jwillmann]

Thank you very much, that was what i was looking for!