Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get the sales values based on previous 6 months

Hi,

I have a client who wants to enter

 

HistoryOctober
HistoryNovember
HistoryDecember
HistoryJanuary
HistoryFebruary
HistoryMarch
ForecastApril
ForecastMay
ForecastJune
ForecastJuly
ForecastAugust
ForecastSeptember

and based on this the data which has three years of data should automatically use the last 12 months and forecast 6 months should be based on previous 6 months average.

I am new to qlikview , Can someone suggest some work arround??

3 Replies
its_anandrjs

Do you want to create another flag field that contains History, Forecast if so.

Try this

Load

If( NumDatefield >= Addmonths(addmonths,-6), 'ForeCast','History') as StatusField

From Location;

Not applicable
Author

Well even then it doesn't work as expected, we are still unable to find the 3 months

its_anandrjs

Provide some data to have a look.