Daily Sales Forcast

rahulsingh12 — Thu, 25 Oct 2018 17:08:29 GMT

Hi I want to create a line chart based on the below data:

I get daily sales data and Budget Data for a SKU

I will have days on x axis

For Days lesser than current day value 0, else for day= Current Date value is of the sale of the day and for days greater than current day it is Budget for the day for all sku *((sum(Actual sales MTD)/sum(Budget MTD for all sku )) {Till the day actual sales data is available for the month}))

how do i code it

Re: Daily Sales Forcast

dplr-rn — Thu, 25 Oct 2018 18:51:41 GMT

Why dont you use set analysis and 2 measures?

some thing like below

Sales - Sum({<MasterDate={"<$(=vMaxDate)"}>}Sales)

Budget - Sum({<MasterDate={">=$(=vMaxDate)"}>}Sales)

vMaxDate is the date where you want to switch over to Budget data

topic Daily Sales Forcast in QlikView

Daily Sales Forcast

Re: Daily Sales Forcast