Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I followed this post to use hierarchy in my Qlik Sense app:
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
Hi,
Try this
Sum(Aggr(Avg(Amount),Node1,Node2,Node3,Node4,Node5))
Regards,
Kaushik Solanki
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?
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
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
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
Hello,
I have also seen this.
Is there any resolution?
Michael
Not yet. Please let me know if you have any solution. Thanks!