Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Weird behavior when using hierarchy in Qlik Sense pivot table

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:

p1.JPG

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

p2.JPG

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

p3.JPG

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

Thanks,

Jing

7 Replies

Re: Weird behavior when using hierarchy in Qlik Sense pivot table

Hi,

Try this

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

Regards,

Kaushik Solanki

Not applicable

Re: Weird behavior when using hierarchy in Qlik Sense pivot table

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?

Re: Weird behavior when using hierarchy in Qlik Sense pivot table

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

Not applicable

Re: Weird behavior when using hierarchy in Qlik Sense pivot table

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:

p4.JPG

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

Re: Weird behavior when using hierarchy in Qlik Sense pivot table

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
Contributor II

Re: Weird behavior when using hierarchy in Qlik Sense pivot table

Hello,

I have also seen this.

Is there any resolution?

Michael

Not applicable

Re: Weird behavior when using hierarchy in Qlik Sense pivot table

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

Community Browser