Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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
Highlighted

Re: Hard coded Syntax not working

3 Replies
Highlighted

Re: Hard coded Syntax not working

Highlighted
Specialist
Specialist

Re: Hard coded Syntax not working

Thank you!

Highlighted
Specialist
Specialist

Re: Hard coded Syntax not working

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))