Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

Accumulation Sum conditional to get month string in Text object

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 string 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)
1 Reply
Support
Support

Re: Accumulation Sum conditional to get month string in Text object

Vinodh, I suspect on this one, you may need to attach a sample app with what you have, so the development folks can have a better look at things including the data model to try to sort out what you have there in order to offer up some suggestions on how to go at it.  The only thing I can give you otherwise is a link to the Design Blog area, you can run some search terms there to see if you can find any posts that may be helpful to you there, about the best I have, sorry.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.