Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
gjbankos1
Contributor
Contributor

expression to give quarterly chart and ignoring all date parameters isn't working

Hello all.  First post, so please forgive my ignorance...

I am trying to put together a quarterly chart that shows the average open warranty days that ignores any date filters applied.  When I put this formula in, it doesn't ignore my date filters that I put in here to ignore.  If I take the top part of the equation (before the '/'), it works.  The bottom part after the '/' does not.  The formula itself is coming back with the right numbers.  I just can't get it to ignore any date filters

I'm not sure what to do here.  Any help would be greatly appreciated and I thank you for your efforts.

Sum({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
Aggr(Avg({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
Aggr(If(Sum({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=,
[CaseStatusDt.calendar_year]=,[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
CaseMonthCloseCnt)= 0,Max({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=,
[CaseStatusDt.calendar_year]=,[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
CaseMonthAgingDays)),CaseNbr,Emp_Name,[CaseStatusDt.CaseFiscalQtrYr])),Emp_Name,[CaseStatusDt.CaseFiscalQtrYr]))
/
Sum({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
Aggr(Count({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=, [CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
DISTINCT Aggr(If(Sum({<CaseStatusDt.fiscal_year=,[CaseStatusDt.fiscal_quarter]=, [CaseStatusDt.fiscal_month_of_year]=, [CaseStatusDt.calendar_year]=,
[CaseStatusDt.calendar_quarter]=, [CaseStatusDt.calendar_month_of_year]=,[CaseStatusDt.CaseCurrentFiscalQtrFlg]=>}
CaseMonthCloseCnt)= 0, Emp_Name),CaseNbr,Emp_Name,[CaseStatusDt.CaseFiscalQtrYr])),Emp_Name,[CaseStatusDt.CaseFiscalQtrYr]))

 

1 Reply
gjbankos1
Contributor
Contributor
Author

bump