topic Target values till date in QlikView

Target values till date

Wed, 22 Jun 2016 09:19:20 GMT

Hi all,

I have scenario where i am calculating sales vs target

example: current year sales/current year target

I have target values all the days in the year but i have sales up to today, So i want current year sales up to date and target value also up to date.

thanks in advance

Re: Target values till date

MK_QSL — Wed, 22 Jun 2016 09:21:36 GMT

This will depend on how you have target... i.e are your target monthly or daily?

Re: Target values till date

Thu, 23 Jun 2016 10:38:35 GMT

daily targets i have

Re: Target values till date

MK_QSL — Thu, 23 Jun 2016 10:59:08 GMT

SUM({<Date = {">=$(=YearStart(Today()))<=$(=Today())"}>}Target)

and

SUM({<Date = {">=$(=YearStart(Today()))<=$(=Today())"}>}Actual)