Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Abhishek1
Contributor III
Contributor III

Set Analysis

Hi,

I have created an expression as follows (please look at the Document Number Part in Set analysis):

sum({$<[Allocation Status]={'Non Self Serve'},[Document Number] = P({$<[Hierarchy Level 1] = {'Business'}, [Hierarchy Level 2],[Hierarchy Level 3],[Hierarchy Level 4]>}[Document Number])>}
Interval(([Approval Date]) - ([First Notification (UTC)]),'D'))

 

I am doing this to get the sum of the Interval in the above expression for the document number that are part of Hierarchy Level 1 = 'Business' but may also be part of other hierarchies. This is working fine. 

here comes the tricky part:

Right now it is showing sum of the Interval against all the Document Numbers. But I want it to show only for the Hierarchy Level 1 = 'Business' data. And when a different selection is made, It must show the sum of Interval for the Document numbers that are common between Hierarchy  Level 1 = 'Business' and that new selection. Please see the attached screenshots. It might help in understanding my issue.

Your help is much appreciated.

Screenshot description:

Screenshot 1 : The expression is currently showing the sum of the document numbers across all the Hierarchies.

Screenshot 2 : The expected sum, It is supposed to show the sum for business only.

Screenshot 3 : Suppose a different hierarchy is selected, Then sum of Document NUmbers that are present in business and that new Hierarchy needs to be shown 

Labels (1)
1 Reply
sunny_talwar

So, what exactly are you getting as the output and what are you hoping to get? Would you be able to share a sample as it would make it easy to see the issue and propose a solution