topic Target vs Achievement in QlikView

Target vs Achievement

Wed, 16 May 2012 01:56:57 GMT

Dear All,

I'm stuck with this for a month now.

I've Sales table : SPid,Sales,Sale_date

Target Table: SPid,Yearly Target for 2012

Problem is i need to create a graph as attached for 2012

Sales is present for 1999,2000,2012, ok we can get only those sales which are in 2012 by year(Sale_date)='2012'

Even if there's no sales in a year the target should be shown on the graph, i.e. for 2012 sales is only for Jan to May, still Target should be a full line till Dec

Plz help

Regards

Target vs Achievement

Jason_Michaelides — Wed, 16 May 2012 10:45:50 GMT

Maybe tick the "Show All Values" checkbox in the dimension tab for Month?

Target vs Achievement

Wed, 16 May 2012 10:59:28 GMT

Hi,

I don't have the months for targets. Need to create them probably by some Master Calendar & then link it to the months of Sales.

Probly create a key of Salesid & some date component(say Month Year).

This is what i've thought but unable to implement. Not sure too whether this will work or not.

Regards

Target vs Achievement

Wed, 16 May 2012 11:39:57 GMT

Hi,

Alternative workaround is to use acummulative expression (on months). Go to dimensions tab and check show all values for month. Then the straight line will continue.

Second alternative is, you above function to get the previous row's values in case of zero. ie., if(sum(sales)=0,above(sum(sales)),sum(sales)).

Regards,

Kiran Rokkam.

Target vs Achievement

Wed, 16 May 2012 11:43:09 GMT

Hi,

These are the things which can be done when i've the months for targets. "Things of the future"

I repeat....I don't have the months just the yearly targets

Regards