topic Re: Graph design in QlikView

Graph design

Wed, 11 Nov 2015 22:23:41 GMT

Hello,

I was wondering if there is a way to do a graph like the one in the picture:

I got my main field thats the 320's-330 (trip) u see in the image. On the DB each register has a trip, the different prices, and the ammount of income.

The graph groups all trips, then the different prices of the trip, and adds the ammount.

I cant figure out how to create a graph like that on QV.

Any ideas?

thanks,

Re: Graph design

petter — Wed, 11 Nov 2015 22:58:07 GMT

Something like this?

Re: Graph design

swuehl — Wed, 11 Nov 2015 23:01:55 GMT

Not sure if I understand your setting.

Have you tried a grouped style bar chart with two dimensions, trip and price, and a sum(AmountIncome) as expression?

Re: Graph design

Thu, 12 Nov 2015 16:57:58 GMT

im not sure how to use this

Re: Graph design

Thu, 12 Nov 2015 17:00:26 GMT

This works when selecting a voyage, but it not like the one on the picture that im trying to create, for several trips.

Re: Graph design

petter — Thu, 12 Nov 2015 17:06:32 GMT

Well you asked if it was possible - and I just wanted to get you to confirm that this would be sufficient layout and presentation wise... If it is I can explain the steps to get it to work. It would be much quicker for me if you have some test-data in Excel or a table-format...

Re: Graph design

Thu, 12 Nov 2015 17:17:22 GMT

I would love the help, im just trying to attach the excel file here but im not sure how, cant find the attach file option

Re: Graph design

petter — Thu, 12 Nov 2015 17:22:20 GMT

You have to get the discussion up fully by clicking on the title-link Graph design and then click REPLY and lastly click "Use advanced editor" to get a link at the bottom of the text input box that says "Attach"....

Yes this is quite cumbersome to find the first time I struggled quite a while before I found how to attach files.

Re: Graph design

Thu, 12 Nov 2015 18:08:17 GMT

o thanks, here it is.

I would like to know how to make this excel show with main field voyage, then freight, and adding net freight.

thanks in advance

Re: Graph design

petter — Fri, 13 Nov 2015 08:04:52 GMT

I think it is quite demanding to achieve a good visualization with the bar chart. I have enclosed a version but also made an alternative approach that might work better in my opinion - hope this works for you.

Re: Graph design

petter — Fri, 13 Nov 2015 09:11:14 GMT

Actually - I found the pivot chart using a gauge mini-chart in one of the expressions a bit interesting so I added Ranks and Totals to it and sorted by the total rank so it is more informative:

Re: Graph design

Fri, 13 Nov 2015 16:31:03 GMT

Thanks alot for your help.

I loved your idea on the table.

KR,