Weird behavior when using hierarchy in Qlik Sense pivot table

[#1]

Hi Experts,

I followed this post to use hierarchy in my Qlik Sense app:

Hierarchies‌

When I expanded Node1 from my pivote table, it looks fine:

then I tried to expand Node2, my other Node2s were missing:

then I expanded Node4, one of my Node3 "Knowledge of Language" missing

I have attached my pvf file for you to check and help me to figure it out. What's wrong here?

Thanks,

Jing

[kaushiknsolanki]

Hi,

Try this

Sum(Aggr(Avg(Amount),Node1,Node2,Node3,Node4,Node5))

Regards,

Kaushik Solanki

[#3]

Thanks Kaushik, but your solution is not working. Does it work on your side? My Qlik sense server version is 2.1. Could it be version related bug?

[kaushiknsolanki]

Hi,

It is because you have null values at node3 and node4 and node5.

Just check the "Include Null Values" in each dimension property and then you will find the values are not changing.

Regards,

Kaushik Solanki

[#5]

Do you mean if there are null values at node3, the node2 will disappear as well? For example, in my case Reading and Writing will not show up.

Anyway, I include Null Values, UI looks pretty bad:

I only want to show the nodes with values. Is it possible?

BTW, I changed the expression to avg instead of sum because I still need the average of the amount, then I see some null nodes have values, what's the reason?

Thanks again!

Jing

[kaushiknsolanki]

Hi,

You need to understand that null values will be counted when used any function. If you do not want the null values then try this.

Avg({<Node5 -= {"$(=isnull(Node5))"}>}Amount)

Remove the "Include Null Values" from dimension properties.

Regards,

Kaushik Solanki

[mstoler]

Hello,

I have also seen this.

Is there any resolution?

Michael

[#8]

Not yet. Please let me know if you have any solution. Thanks!