topic Set Analysis within Set Analysis in QlikView

Set Analysis within Set Analysis

Abhishek1 — Tue, 11 Jun 2019 13:56:00 GMT

I have an expression.

=Count({<Hierarchy_level_1={'Business'}>}Document_Number)

I want to replace the set analysis with "Select all the document number where Hierachy Level 1 is Buisness".

The reason I am doing this is because there are values in Hierarcy level 2 which dont come under Hierarchy Level 1 "Buisness". But these Hierarchy level 2 values have Document numbers associated with them that come under "Business". when someone selects a Hierarchy level that dose not associate with Hierarchy Level 1 "Buisness" will show data for all the Document number common Between Hierarchy level 2 selection and the ones that come under Hierarchy Level 1 "Buisness".

I have written the Following set analysis foe the same but it dosent seem to work.

=COunt({$<[Document Number]=P({$<[Hierarchy Level 1]={'Procurement'}>}[Document Number])>}distinct[Document Number])

can anyone please help. Its very urgent.

Re: Set Analysis within Set Analysis

Abhishek1 — Tue, 11 Jun 2019 14:28:32 GMT

For better under standing of the problem I have tried to simplify it below:

suppose field Hierarchy level 1 has a value 'Business'. Anothwer fiel 'document number' has values 1,2,3,4,5 associated with this hierarchy Level 1 ='Business ' . Now suppose some one selects a value from field Hierarchy Level 2 has a value 'X' and this 'X' dosent come under hierarchy Level 1 'Business '(It becomes grey when hierarchy Level 1 ='Business ) . but This X has document number 2,3 associated with it.

Now if some one selects this Hierarchy Level 2 'X' the data should be shown for document number 2,3.
But if I write this expression

=count({<Hierarchy Level 1 ={'Business'}>}Document_number)

this expression will give '0' as output as Hierarchy Level 2 'X' dosent come under Business. So instead I am trying to bring the document number associated with the Hierarchy level 1 Business. Something like this.

=Count({$<[Document Number]=P({$<[Hierarchy Level 1]={'Business'}>}[Document Number])>}distinct[Document Number]).

I am expecting this set analysis to give me THe Docuemnt numbers associated with Business.So it becomes something like this:

=Count({<Document Number = {1,2,3,4,5}>}Document Number). If this works and Some one selects Hierarchy Level 2 'X'. The data should be shown as Hierarchy Level 2 'X'' as Document number 1,2 associated with it.

but its not working

Re: Set Analysis within Set Analysis

sunny_talwar — Tue, 11 Jun 2019 15:08:26 GMT

Try this

=Count({$<[Document Number] = P({$<[Hierarchy Level 1] = {'Business'}, [Hierarchy Level 2]>}[Document Number])>} DISTINCT [Document Number])