topic Re: Daily Data vs a Total Target in QlikView

Daily Data vs a Total Target

Thu, 30 Apr 2015 14:34:47 GMT

Hello,

I have daily figures for one set of data, with another set of data on a monthly basis (a target).

I can graph the daily sales which accumulate, however I want to track these against a target which I have at a monthly level.

i.e.

Is there an easy way to do this please?

Many Thanks

Re: Daily Data vs a Total Target

sunny_talwar — Thu, 30 Apr 2015 14:39:41 GMT

Not sure if I completely understand your question. Is your dimension month or day here?? Please provide a sample if you could.

Best,

Sunny

Re: Daily Data vs a Total Target

Thu, 30 Apr 2015 14:43:52 GMT

Ie. I have sales daily but a target at a monthly level:

DAY SALES

day1 10

day2 15

day3 20

day4 25

day5 30

day6 35

But with a target of the total month ie. 50

So when It is graphed it looks like this:

As the target is not split down to a daily level

Re: Daily Data vs a Total Target

sunny_talwar — Thu, 30 Apr 2015 14:45:53 GMT

So for each day you would show 50 as the target??? compared to cumulative sales

Is that what the goal is?

Best,

Sunny

Re: Daily Data vs a Total Target

Thu, 30 Apr 2015 14:49:09 GMT

No, I would want to calculate the target per day so 50/6 = 8.3

DAY SALES TARGET

day1 10 8.3

day2 15 8.3

day3 20 8.3

day4 25 8.3

day5 30 8.3

day6 35 8.3

On a graph this would then be able to be accumulated back up to 50

Re: Daily Data vs a Total Target

sunny_talwar — Thu, 30 Apr 2015 15:01:43 GMT

Have a look at the attached qvw file, is this close to what you are looking for? I didn't have the data structure with me so I used hardcoded 50 here, but have a look.

Best,

Sunny

Re: Daily Data vs a Total Target

ramoncova06 — Thu, 30 Apr 2015 15:44:06 GMT

I normally break down the monthly target into a daily target based on the numbers of days in a month

Re: Daily Data vs a Total Target

Fri, 01 May 2015 07:28:19 GMT

Yes I can do that, also but it does not have any relationship to the days?