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

If statement and set Analysis Dimension

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

 

2018-12-11_10-05-16.jpg

2 Replies
jyothish8807
Master II
Master II

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

Best Regards,
KC
cbaqir
Specialist II
Specialist II
Author

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