Set analysis in Average Aggr Sum function (Select Not In) not working.

Marcushenriquesk — Thu, 17 Feb 2022 18:41:02 GMT

So I have a avg aggr sum function on one of my tables which is shown below:

=avg(aggr(Sum({<[TEST_ID]-={'>=90000<=99999'},[PANEL_ID]-={'>=30000<=39999'}>}Interval(RUN_DATE_TIME-RECEIVED_DATE_TIME))*24 ,ACC_ID))

The purpose of this function is to select the average interval between two dates per 'ACC_ID.' The set analysis is used to filter out ranges for two fields; 'PANEL_ID' and 'TEST_ID' as show per the '-='. However it's not working, I'm not sure if the syntax I used for the set analysis is not proper or... But, with this function in place and when I create a selection for panel id or test id within the ranges there is still data populating.

Re: Set analysis in Average Aggr Sum function (Select Not In) not working.

Lisa_P — Fri, 18 Feb 2022 01:18:26 GMT

For ranges or wildcards you need double quotes inside curly brackets ..

=avg(aggr(Sum({<[TEST_ID]-={">=90000<=99999"},[PANEL_ID]-={">=30000<=39999"}>}Interval(RUN_DATE_TIME-RECEIVED_DATE_TIME))*24 ,ACC_ID))

topic Set analysis in Average Aggr Sum function (Select Not In) not working. in QlikView

Set analysis in Average Aggr Sum function (Select Not In) not working.

Re: Set analysis in Average Aggr Sum function (Select Not In) not working.