Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Set Analysis

Hi All,

I have written an expression as Follows:

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


This expression is suppose to give me the sum of the interval Where Hierarchy Level 1 ='Business' and also in case a different hierarchy is selected, then IT will show the sum of interval for all the Document numbers that are common between Hierarchy level 1 = 'Business' and that selection.

This works fine, untill I make a selection. Suppose I select a hierarchy level 2, then the values OF Text boxes showing Hierarchy level 1 data becomes '0'. while the data for Hieararchy level 2, Hierarchy level 3 and 4 are showing correct.

Similarly when  I select a hierarchy level 3, then the values OF Text boxes showing Hierarchy level 1 and Hierarchy level 2 data becomes '0'. while the data for Hieararchy level 3, Hierarchy level 4  are showing correct. and so on.

Can anyone help me with this?


Labels (1)
3 Replies


Are these hierarchies part of same hierarchy? I suspect that your p() might not be required or  not used appropriately. Could you share a sample and explain expected behavior/output there?

Contributor III
Contributor III

Hi Tresesco,

These hierarchies are different fields of the same table. There are four hierarchies, Hierarchy Level 1,2,3,4. There are hierarchies in which are not depended on one another, but enen then these have Document numbers that fall uner each of them most of the times. I am trying to create a \sample data. will update once it is done. It is a bit difficult.



Not sure if this is really of any help or not, but wanted to drop it in here just in case:


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.