topic Cummulative Sales vs Plan chart - advise please in QlikView

Cummulative Sales vs Plan chart - advise please

Tue, 20 Dec 2011 16:06:43 GMT

Hi,

I am trying to define a line chart to show cummulative sales by day vs cummulative planned values by day within a selected period.

I want the graph to show the Plan cummulative values for all days within the selected period that exist on the Plan table and the Sales cummulative values for the days that exist on the Sales table for that same period. Ideally the sales line should stop when there are no more sales for the rest of that period.....

so it should look something like the image shown - green line = sales and red line = plan

Any ideas how I would acheive this?

Cummulative Sales vs Plan chart - advise please

vgutkovsky — Tue, 20 Dec 2011 17:25:39 GMT

If you select "Full Accumulation" in the Expressions tab for both expressions, that should accomplish what you want.

Regards,

Vlad

Cummulative Sales vs Plan chart - advise please

Wed, 21 Dec 2011 08:22:19 GMT

Thanks for the response. I've tried that, but only get a plan line extending for the dates that match the sales transaction dates. Perhaps it is the way in which I have defined/loaded my tables.

Cummulative Sales vs Plan chart - advise please

vgutkovsky — Wed, 21 Dec 2011 16:00:08 GMT

It might be...can you post a reduced sample?

Cummulative Sales vs Plan chart - advise please

Thu, 22 Dec 2011 10:25:02 GMT

Hi Vlad,

I created simple spreadsheets for plan data and transaction data and pulled those into a new QV. This now shows the full date axis for the plan data which is what I want . The transaction line 'FLAT LINES' for the balance of the period where there are no transctions, which would be correct for any closed preiod. Is there a way that I can make the transaction line stop when it reaches the current date in the graph if I were showing the current period? It would look a bit neater.

Re: Cummulative Sales vs Plan chart - advise please

sridhar240784 — Thu, 22 Dec 2011 12:41:18 GMT

Hi,

Check this attached application.

Hope this helps you.

-Sridhar

Cummulative Sales vs Plan chart - advise please

Thu, 22 Dec 2011 13:01:54 GMT

Thanks Sridhar, this is what I am after.

Cummulative Sales vs Plan chart - advise please

suniljain — Thu, 22 Dec 2011 13:08:59 GMT

if you have huge data then it is good to implement it in script level