Hi qlik sense experts
i use advanced analytic tool to forecast the category's sale, after i have the output i link output between the historical and forecast in link table (from data editor in qlik sense). But after i done that, i figure out all of the result that i done before had changed (YTD,MTD and so on) and i realise the problem of that is the timeline. I also think about the variable solution but actually i don't know how to set variable for that. Could anybody help me with that?
P/S: This is my historical data and forecast data. (attached below)
