topic Re: CHART CUSTOM in QlikView

CHART CUSTOM

Tue, 28 Jan 2014 17:19:35 GMT

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.

Re: CHART CUSTOM

Christian_Lauritzen — Tue, 28 Jan 2014 17:22:01 GMT

Could you upload the data? /Christian

Re: CHART CUSTOM

Tue, 28 Jan 2014 17:49:58 GMT

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??

Re: CHART CUSTOM

Clever_Anjos — Tue, 28 Jan 2014 17:51:51 GMT

Product1,Product2, etc are the same field?

Re: CHART CUSTOM

jerem1234 — Tue, 28 Jan 2014 18:16:42 GMT

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!

Re: CHART CUSTOM

Christian_Lauritzen — Tue, 28 Jan 2014 20:29:08 GMT

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

Re: Re: CHART CUSTOM

Christian_Lauritzen — Tue, 28 Jan 2014 20:32:43 GMT

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!

Re: Re: CHART CUSTOM

Christian_Lauritzen — Tue, 28 Jan 2014 20:40:42 GMT

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

Re: CHART CUSTOM

Wed, 29 Jan 2014 07:31:16 GMT

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

regards

Re: CHART CUSTOM

Wed, 29 Jan 2014 07:31:55 GMT

yes it will be the same field