Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik__Vinodh
Partner - Contributor III
Partner - Contributor III

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 - Contributor III
Partner - Contributor III
Author

Hi friends,

 

any solution on above query..

 

 

Brett_Bleess
Employee
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.