Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

I want add 2023 data graph to current date.

current graph :

Sxbbb_0-1680163372325.png

New graph :

I want add 2023 data graph to current date.

Sxbbb_2-1680163685446.png

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.

 

0 Replies