Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi friends,
any solution on above query..
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