Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to analyse next month orders

Hi ,All

data base table consists company Id ,month wise orders.

how can i analyse  next month Orders by using last last six month data.

That mean how many orders can i except next month based on company wise

Thanks

ramu.

11 Replies
Not applicable
Author

Could you please explain  detail about forecasting

pratap6699
Creator
Creator

in your sample table contains order id with 6 months sales, if you select jan month chart display july to december sales......suppose select july  it shows jan to june sales right? then go to this expression on chart-->

sum({<month={">=$(=min(month))<=$(=min(month)-6)"}>}sales)