topic Forecast with current date in QlikView

Forecast with current date

Tue, 28 Oct 2014 12:57:44 GMT

Hi all!

I have value SALES - it is Fact.

I want calculated SALES_forecact on another day.

I want use this formula SALES_forecast = day(1-31 for example January) * SALES/ count(day this month)

SALES for example 100

If am choose 15 day in January i have 100*15/31

If am choose 28 day in Marth i have 100 * 20/31

Why can help me

Tue, 28 Oct 2014 13:03:35 GMT

Hi,

Try this,

Sales* (getselectedfield(day(datefield))/ getselectedfield(Max(day(datefield)))

Tue, 28 Oct 2014 14:18:48 GMT

Thank ' s but that is getselectedfield - is function - i don't fund this or that do you mind.

max(day(datafield) - is good work but if a do

sales * day(datafield)/max(day(datafield)

i don't show value for all month , a can show only if day is choose

jonathandienst — Tue, 28 Oct 2014 14:31:01 GMT

If month and day are in your dimensions, then something like this should work:

Sum(sales) * day(datafield) / Max(TOTAL <month> day(datafield))

Remember that QV field names are case sensitive, so [sales] is a different field than [SALES].

HTH

Jonathan

jonathandienst — Tue, 28 Oct 2014 14:34:18 GMT

Or better

Sum(sales) * day(datafield) / day(MonthEnd(datafield))

Wed, 29 Oct 2014 07:59:36 GMT

Thank you, Jonathan!