topic Re: Need Help on Logic Preparation in QlikView

Need Help on Logic Preparation

agni_gold — Wed, 05 Jul 2017 12:32:19 GMT

Hi Friends,

I have a situation:

I have data for forecasting, in which every month client is doing forecasting for 2 years, and on the same month they are giving a number called PlaningVersion (Example if Planing is done in Feb 2016, then version no will be 602 (Year last digit + 2 digit of current month))

So I need to calculate Lag3 for my data,

so suppose if I am calculating Lag3 for Dec2017, means its planning version would be 712, so it will sum data for Nov2017+Oct2017+Sep2017 for Planing version 709, means 3 months back (version 709) whatever planning was done for Nov, Oct, Sep will be the Lag3 for Dec2017 (version 712)

Hope I have explained correctly, But this thing I need to do at script level,

Also attaching sample data

Re: Need Help on Logic Preparation

kaushiknsolanki — Wed, 05 Jul 2017 12:40:25 GMT

Can you give output data from the sample data which you have given, so that it will help to understand it better.

Regards,

Kaushik Solanki

Re: Need Help on Logic Preparation

agni_gold — Wed, 05 Jul 2017 14:50:47 GMT

Hi friends,

Required output i have attached. please help

Re: Need Help on Logic Preparation

agni_gold — Wed, 05 Jul 2017 14:51:32 GMT

Hi Friend,

Attached required output with logic i want.

Re: Need Help on Logic Preparation

agni_gold — Wed, 05 Jul 2017 15:29:24 GMT

tresesco‌ can you please help here.

Re: Need Help on Logic Preparation

agni_gold — Wed, 05 Jul 2017 16:10:09 GMT

gwassenaar‌ can you please help here ?

Re: Need Help on Logic Preparation

Anonymous — Wed, 05 Jul 2017 17:39:09 GMT

Hi Agnivesh,

Please find the attached qvw and let me know if this is what something you are looking for.

Thanks

Mouna Chandra

Re: Need Help on Logic Preparation

agni_gold — Wed, 05 Jul 2017 17:46:24 GMT

thanks bro , but this is not matching with my desired result as i attached.

Re: Need Help on Logic Preparation

Anonymous — Wed, 05 Jul 2017 17:50:03 GMT

What i did was i have taken right(YearMonth,3) as version and did group by on version to sum all the forecast values groupby version.

Is this logic correct? you said you want to sum previson three months to get forcast for latest month right.

Re: Need Help on Logic Preparation

agni_gold — Wed, 05 Jul 2017 17:57:01 GMT

sum previous three months to get the forecast for the latest month right.

Correct logic:

sum previous three months of Version-3 will be my current month forecast.

Re: Need Help on Logic Preparation

Anonymous — Wed, 05 Jul 2017 18:11:24 GMT

I am sorry i am not able to understand. Is doing group by clause on version to get sum of forcast is correct logic, after that we can do sum of previous three months.

Re: Need Help on Logic Preparation

agni_gold — Wed, 05 Jul 2017 18:14:30 GMT

I am giving one example here

707

Jul-17

241.9525005

(Sum of Jun2017+May2017+Apr2017 of Planning Version 704

Hope you will understand.