current graph :
![Sxbbb_0-1680163372325.png Sxbbb_0-1680163372325.png](https://community.qlik.com/t5/image/serverpage/image-id/103831iDF1F42B814692098/image-size/medium?v=v2&px=400)
New graph :
I want add 2023 data graph to current date.
![Sxbbb_2-1680163685446.png Sxbbb_2-1680163685446.png](https://community.qlik.com/t5/image/serverpage/image-id/103833i59151E9354AC1AFD/image-size/medium?v=v2&px=400)
Code used Dimensions :
=if(K_Year>Year(Today(0)-1)-1,date(K_MonthYear,'$(vMonthYearFormat)'),
if(K_Year>Year(Today(0)-1)-3,K_Year))
Code used Expressions:
f(GetFieldSelections(Work)='IN',
Sum({<Work={'IN'},Plant=,Center=,Process=,Name=,[Time - Year]=,[Time - Month]=,[Time - Day]=>} if(Type='PC',PCS_SSM,if(Type='SQ',SQ_SSM)))
/Sum({<Work={'IN'},Plant=,Center=,Process=,Name=,[Time - Year]=,[Time - Month]=,[Time - Day]=>} if(Type='PC',BasePC,if(Type='SQ',SQ_SSM))),
Sum({<Work={'OUT'},Plant=,Center=,Process=,Name=,[Time - Year]=,[Time - Month]=,[Time - Day]=>} if(Type='PC',PC_SSM,if(Type='SQ',SQ_SSM)))
/Sum({<Work={'OUT'},Plant=,Center=,Process=,Name=,[Time - Year]=,[Time - Month]=,[Time - Day]=>} if(Type='PC',BasePC,if(Type='SQ',SQ_SSM))))
I want add 2023 data graph to current date.