Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

Hard coded Syntax not working

The top left chart should not need to have the PROCESS_STEPs of Submitted to Routing and Routed selected to show the correct numbers. I tried to hardcode it in the expression but I guess I didn't do it correctly.

I will export this to NPrinting so I don't want it to be dependent on list box selections.

1 Solution

Accepted Solutions
sunny_talwar

3 Replies
sunny_talwar

Check attached

cbaqir
Specialist II
Specialist II
Author

Thank you!

cbaqir
Specialist II
Specialist II
Author

Sunny,

I am trying to make this chart be a rolling 3 months and I am having trouble with the syntax.

Do you see the issue?

sum({$<
PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'},
//IS_IN_PROD = {'Y'},
MONTH_1 = {"$(='>=' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), -3), 'MM-YY')) & '<' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), 0), 'MM-YY')))"}>}
Aggr(Max({$<
PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'},
//IS_IN_PROD = {'Y'},
MONTH_1 = {"$(='>=' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), -3), 'MM-YY')) & '<' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), 0), 'MM-YY')))"}>}
PROCESS_STEP_START_DATE) -
Min({$<
PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'},
//IS_IN_PROD = {'Y'},
MONTH_1 = {"$(='>=' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), -3), 'MM-YY')) & '<' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), 0), 'MM-YY')))"}>}
PROCESS_STEP_START_DATE)
,
DEFECT_ID))/
(
Count({$<
PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'},
//IS_IN_PROD = {'Y'},
MONTH_1 = {"$(='>=' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), -3), 'MM-YY')) & '<' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), 0), 'MM-YY')))"}>} DISTINCT
DEFECT_ID))