Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Abhishek1
Contributor III
Contributor III

Set Analysis

Hi,

 

I am trying to write a set analysis. In this I want the sum of cycle time where Hierarchy Level 1 is 'Business'. The thing is when I am explicitly state 'Business' there are some Hierarchy level 2 selections that show zero data as those dont come under Hierarchy Level 1 'Business'. But those selections have some document numbers which are common to  Hierarchy Level 1 'Business'. Thats why I am trying to bring in the Document numbers in the set analysis so that the selections in Hierarchy Level two will be represented in the set analysis and data should be shown for those selections as well.

Here is my Initial set analysis:

=sum({$<[Hierarchy Level 1]={'Business'}>}[Cycle Time])

here is my failed attempt for bringing in the Document Number:

=SUM({$<[Document Number]=P({<[Hierarchy Level 1]={'Business'}>}) >}[Cycle Time]).

can anyone help me where I am going wrong here?

Thanks

 

Labels (2)
2 Replies
Anonymous
Not applicable

I suppose you forgot to add the field Document Number in your P function

=SUM({$<[Document Number]=P({<[Hierarchy Level 1]={'Business'}>}[Document Number]) >}[Cycle Time]).

jonathandienst
Partner - Champion III
Partner - Champion III

Perhaps this:

Sum({$<[Document Number] = P({<[Hierarchy Level 1] = {'Business'}>}) [Document Number]>} [Cycle Time])

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein