Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Forecast with current date

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

5 Replies
Not applicable

Re: Forecast with current date

Hi,

Try this,

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

Not applicable

Re: Forecast with current date

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

MVP
MVP

Re: Forecast with current date

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Re: Forecast with current date

Or better

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Forecast with current date

Thank you, Jonathan!

Community Browser