topic Re: If statement and set Analysis Dimension in QlikView

If statement and set Analysis Dimension

cbaqir — Tue, 11 Dec 2018 17:07:14 GMT

TECHNICAL SPECS
ART Volume by Week Submitted to ART = aggr(max( {$<COM_CAT={'ART - AMB Refinement Team'}>}WeekStart(COM_CAT_START_DATE)),DEFECT_ID)
Only show tickets that hit COM_CAT={'ART - AMB Refinement Team'} 2+ times and where the min(COM_CAT_START_DATE) to COM_CAT={'ART - AMB Refinement Team' was after 11/2/18
Distinct count of DEFECT_ID

This doesn't seem to work:

=if(COM_CAT_START_DATE>'11/02/2018'
and aggr(count({$<COM_CAT={'ART - AMB Refinement Team'}>}COM_CAT),DEFECT_ID)>=2,
aggr(max( {$<COM_CAT={'ART - AMB Refinement Team'}>}WeekStart(COM_CAT_START_DATE)),DEFECT_ID))

Re: If statement and set Analysis Dimension

jyothish8807 — Wed, 12 Dec 2018 08:33:44 GMT

Hi Cbaqirdhds,

Please try like this.

=if(count(total <DEFECT_ID>{<COM_CAT={'ART - AMB Refinement Team'},COM_CAT_START_DATE= {'>11/02/2018'}>} COM_CAT)>=2,
weekstart(max( total <DEFECT_ID>COM_CAT_START_DATE))))

Re: If statement and set Analysis Dimension

cbaqir — Wed, 12 Dec 2018 15:21:18 GMT

Thanks but that doesn't seem to work. I get an error and then repeating DEFECT_IDs.