add the month id + lock period

[stephenedberkg]

in this screen shot if my current month is sep-15 mean i want to show the Dec-15 values for the 1st id because lock period for that id is 3.

in second one lock period is 2 so i want to show the nov-15 values like wise.

any suggestion?

i have different lock period for different id.

i want to add this lock period to month id.

i want to achieve this either in script or set analysis?

[jonathandienst]

I suggest that you post your qvw or a representative sample as the solution will depend on your data set.

See this: Preparing examples for Upload - Reduction and Data Scrambling

[stephenedberkg]

See the attchment.

[jonathandienst]

By "current month" do you mean a month selected by the user? Then you want to display data forward for the lock period based on this selection?

[stephenedberkg]

yes you are correct