Adding Stock month

[stephenedberkg]

Hi all,

i have product id with different stock months,i want to add this stock month with my current selection month.

i want to achieve this sales month (i.e,stock month+month)

whether in script or in set analysis.

please see the attachments

Regards,

stephen

[Anonymous]

In QV or Excel?

[stephenedberkg]

in QV only.

[Anonymous]

What if Month+Stockmonth > 10??

Like, Month =8 and StockMonth=12 then Salesmonth=20??

[manojkulkarni]

Better you create it in Qlikview & use in your calculations

[stephenedberkg]

yes next year 8 th month . i am using month IDs

[stephenedberkg]

see the attachment?

[asgardd2]

You wrote in the text box:

“The upload month jan has 12 month forecast data i want the particular month datas only based on lock period.each id has different lock period.if i select the Upload month jan and the id is 2 i want to show the march data  because it lock period is 2i want to show sales of selected month + lock period in forecast date. upload calaendar is my original calendar”

Do you want to see march data, because Jan(1) + lockData(2) = 3(March)?

Perhaps, this solution will help you. (in attach.)