topic Re: combined graph in QlikView

combined graph

warrentk80 — Thu, 21 Jan 2016 13:41:43 GMT

Goodmorning everyone

attached an example of a dashboard that would like to achieve

for convenience I imported the database directly in the script via the load inline.

the obbettivo is to represent a combined graph with the trend with the ratio of the budget and purchases.

the budget year is distributed under the budget for the current month (in this case (11/2015) divided the month to month value.

purchases must instead be represented by retrieving data from the purchases table but is valued only for a few months

what I want to achieve is a similar result to the one shown in the figure, with both representations

Thanks to all for your cooperation

Andrea

Re: combined graph

sunny_talwar — Thu, 21 Jan 2016 13:49:49 GMT

I don't see Vendite in the attached application?

Re: combined graph

warrentk80 — Thu, 21 Jan 2016 13:55:53 GMT

I do not have the sales 2 graphics should represent the budget divided for months according to the formula specified in the instrument panel and purchases

I put databases on script using load inline

Re: combined graph

warrentk80 — Thu, 21 Jan 2016 14:37:52 GMT

you're right in the second formula should be written on (buying) and sum (sales), but even so you see a single line width distributed throughout the year.

Re: combined graph

sunny_talwar — Thu, 21 Jan 2016 14:39:10 GMT

What is sales field name referred in your app?

Re: combined graph

sunny_talwar — Thu, 21 Jan 2016 14:41:55 GMT

Besides not know what the sales field is, the bigger issue is that your tables are not connected to each other.

One a similar post by you, I did provide a solution, where I connected the two tables so that on a single chart you are able to see the result you are hoping to see (Re: graphic Mixed)

Isn't this the same thing you are trying to do?

Re: combined graph

warrentk80 — Thu, 21 Jan 2016 14:44:31 GMT

where the field on which to do the expression for the second graph is Buying

attached the correct example

Re: combined graph

warrentk80 — Thu, 21 Jan 2016 14:48:27 GMT

I tried with the solution that I had proposed but is in script and I can not apply it.
you can not resolve it at the level of expression on the graphical object?

Re: combined graph

sunny_talwar — Thu, 21 Jan 2016 14:49:14 GMT

New Data Model:

Output Required:

Re: combined graph

sunny_talwar — Thu, 21 Jan 2016 14:49:48 GMT

I can try it now because you did not mention this before.

Re: combined graph

sunny_talwar — Thu, 21 Jan 2016 14:55:40 GMT

Without changes to script solution:

Expression for red line:

=Aggr(If(OrdinamentoMese = Mese, Sum(Acquisti)), OrdinamentoMese, Mese)

Re: combined graph

warrentk80 — Thu, 21 Jan 2016 15:43:21 GMT

I would say that the result is correct.
just one more thing I'm sorry
I sent you an example handwritten
actually in the database field the month is called the month for both purchases and sales.
I tried to modify the expression, but when I select a time I go to see the budget data but only the point on the sale today, but if not I select the period shows me only four months of sales, but not the budget
Could you ottonere the result that you sent me first with this database?
keep in mind that the month must always be selected and to defaul is the last.
Thank you
Andrea

Re: combined graph

sunny_talwar — Thu, 21 Jan 2016 16:28:31 GMT

Check out the attached: