topic Re: Adding Stock month in QlikView

Adding Stock month

stephenedberkg — Wed, 20 Jan 2016 06:07:45 GMT

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

Re: Adding Stock month

Anonymous — Wed, 20 Jan 2016 06:19:05 GMT

In QV or Excel?

Re: Adding Stock month

stephenedberkg — Wed, 20 Jan 2016 06:21:35 GMT

in QV only.

Re: Adding Stock month

Anonymous — Wed, 20 Jan 2016 06:26:38 GMT

What if Month+Stockmonth > 10??

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

Re: Adding Stock month

manojkulkarni — Wed, 20 Jan 2016 06:28:33 GMT

Better you create it in Qlikview & use in your calculations

Re: Adding Stock month

stephenedberkg — Wed, 20 Jan 2016 06:30:28 GMT

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

Re: Adding Stock month

stephenedberkg — Wed, 20 Jan 2016 06:32:00 GMT

see the attachment?

Re: Adding Stock month

asgardd2 — Wed, 20 Jan 2016 09:00:23 GMT

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.)