Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

Set Analysis Intersection

Can someone help me with the right syntax to get the intersection of these expressions? I am trying to get the counts of DEFECT_ID where the DETECT_DATE >= AddMonths(Today(),-12) AND where the CLOSE_DATE >= AddMonths(Today(),-3).

Count({$<DEFECT_ID *= {"=Min({1}DETECT_DATE) >= AddMonths(Today(),-12)"}>}DISTINCT DEFECT_ID)

Count({$<DEFECT_ID *= {"=Min({1}CLOSE_DATE) >= AddMonths(Today(),-3)"}>}DISTINCT DEFECT_ID)

Labels (1)
1 Reply
stevejoyce
Creator III
Creator III

Count({$<DEFECT_ID *= {"=Min({1}DETECT_DATE) >= AddMonths(Today(),-12) and Min({1}CLOSE_DATE) >= AddMonths(Today(),-3)"}>}DISTINCT DEFECT_ID)