Accumulation Sum conditional to get month string in Text object

Qlik__Vinodh — Sat, 16 Nov 2024 02:54:19 GMT

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

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

Brett_Bleess — Tue, 20 Aug 2019 13:48:38 GMT

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

topic Accumulation Sum conditional to get month string in Text object in QlikView

Accumulation Sum conditional to get month string in Text object

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