Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik__Vinodh
Partner - Creator II
Partner - Creator II

Accumulation Sum conditional to get month string in Text object QV

Hi Community Members,

i am seeking help on below query!

i have Month and Actual like below table.

Month

Actual

Nov-17

0.6

Dec-17

0.7

Jan-18

0.3

Feb-18

0.5

Mar-18

0.6

Apr-18

0.7

May-18

0.8

Jun-18

0.9

Jul-18

0.7

Aug-18

0.6

Sep-18

0.8

Oct-18

0.5

Nov-18

0.4

Dec-18

0.2

Jan-19

0.2

Feb-19

 

Mar-19

 

Apr-19

 

May-19

 

Jun-19

 

Jul-19

 

Aug-19

 

Sep-19

 

Oct-19

 

Nov-19

 

 

 

Logic Example table Below:

 

Month

Actual

Forecast Actual Saving

Formula (Forecast Actual Saving)

Saving %

Forecast Accumulation

 

Nov-17

0.6

     

Dec-17

0.7

     

Jan-18

0.3

     

Feb-18

0.5

    

Actual

Mar-18

0.6

    

Forecast

Apr-18

0.7

     

May-18

0.8

     

Jun-18

0.9

     

Jul-18

0.7

     

Aug-18

0.6

     

Sep-18

0.8

     

Oct-18

0.5

     

Nov-18

0.4

0.2

Nov17- Nov18

33%

  

Dec-18

0.2

0.5

Dec17 - Dec18

71%

 

Average L3M

Jan-19

0.2

0.1

Jan18 - Jan19

33%

0.1

46%

Feb-19

 

0.23

Feb18 * 46%

46%

0.33

 

Mar-19

 

0.28

Mar18 * 46%

46%

0.61

 

Apr-19

 

0.32

Apr18 * 46%

46%

0.93

 

May-19

 

0.37

May18 * 46%

46%

1.30

 

Jun-19

 

0.41

Jun18 * 46%

46%

1.71

 

Jul-19

 

0.32

Jul18 * 46%

46%

2.03

 

Aug-19

 

0.28

Aug18 * 46%

46%

2.31

 

Sep-19

 

0.37

Sep18 * 46%

46%

2.68

Result Month

Oct-19

 

0.23

Oct18 * 46%

46%

2.91

 

Nov-19

 

0.18

Nov18 * 46%

46%

3.09

 

Dec-19

 

0.09

Dec18 * 46%

46%

3.18

 

-when Forecast Accumulation field reach to 2.5 then need that month name in text object. it is like which month it is crossing 2.5 sale want to know in text box.  can you please help on this if possible.

-Average L3M is computed based on Savings % field from Nov18 to Jan19 (46%).

 

Output Month Name : Sep-19

 

Thanks & Regards,

Vinodh

Labels (1)
2 Replies
Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

Hi friends,

 

any solution on above query..

 

 

Brett_Bleess
Former Employee
Former Employee

Duplicate post, see https://community.qlik.com/t5/New-to-QlikView/Accumulation-Sum-conditional-to-get-month-string-in-Te... for the other thread.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.