Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

wayneantinore-a
Contributor

Problem using set analysis with aggregate and rangesum

Hi, I'm creating a chart that uses set analysis to restrict the output.  Everything seemed to be working but then I noticed that a dimension value is being returned for items that are being excluded by the set analysis.  In the chart image below the hour for 6am shows up but there is no information for 6am based on my set analysis.  The information for 6am is for departments not included. 

SetAnalysisIssue.JPG

I've tried putting the set analysis right after the AGGR, on the individual counts and on all of them but 6am is always being returned.  Here are my AGGR functions for reference.  Thanks in advance for any help.

Aggr(RangeSum(Above(Count({$<Department_Name = {'CHEMISTRY','HEMATOLOGY'}>}[Order#])/

Count({$<Department_Name = {'CHEMISTRY','HEMATOLOGY'}>}TOTAL <Date_Receive> [Order#]), 0, RowNo())),Date_Receive,(Received_Hour,Numeric()))

Aggr({$<Department_Name = {'CHEMISTRY','HEMATOLOGY'}>} RangeSum(Above(Count([Order#])/

Count(TOTAL <Date_Receive> [Order#]), 0, RowNo())),Date_Receive,(Received_Hour,Numeric()))

1 Solution

Accepted Solutions

Re: Problem using set analysis with aggregate and rangesum

Try to uncheck 'Include Zero Values' undre Add-ons -> Data handling

2 Replies

Re: Problem using set analysis with aggregate and rangesum

Try to uncheck 'Include Zero Values' undre Add-ons -> Data handling

wayneantinore-a
Contributor

Re: Problem using set analysis with aggregate and rangesum

Thanks Sunny!  That was it.

Community Browser