CHART CUSTOM

[#1]

I NEED CREATE A CHART  LIKE THIS

I need count the change if i had contract product 1 and change to product 2 etc

Regards.

what field i need to do this? please explain me this.

[Christian_Lauritzen]

Could you upload the data? /Christian

[#3]

there are ficticius data.

I have no data yet.. but i see this in other solution and probably i will reproduce it in qlikview.

Wich data i will need??

[Clever_Anjos]

Product1,Product2, etc are the same field?

[jerem1234]

You can create something similar. You can use a pivot table with two dimensions, Old and New. Then for the expression, do your value. Of course, how easy it will be will be based on what your data looks like.

Used this data:

Load * Inline [

Old, New, Count

Product 1, Product 1,

Product 1, Product 2,25

Product 1, Product 3,40

Product 2, Product 1,12

Product 2, Product 2,

Product 2, Product 3,111

Product 3, Product 1,22

Product 3, Product 2,49

Product 3, Product 3,

];

Your data is probably different, since I doubt Count is as easy as just a field.

Hope this helps!

[Christian_Lauritzen]

It did. I made a file you can work from. Cannot find an attach button to give you the QVD. Will save and try again.

/Christian

@

[Christian_Lauritzen]

Ok. Had to change browser. Attached via the advanced editor is not available in Chrome... Also fixed the background color in the left column compared to the screenshot above so it is like you requested.

Here you go!

[Christian_Lauritzen]

Seems like I created a solution based on a solution.... Sorry jerem1234. Looked at your picture and took it for the original request.

[#9]

thanks a lot for the answer... i will wait for the data!!

regards

[#10]

yes it will be the same field