Hey Guys, I wish to communicate that I think there is a bug in this case.
Few days ago, I got stuck calculating the aggregate of the average of a hierarchical function.
I found the solution in the easiest way you can do : Treating the name of the Hierarchical Group as a Variable.
The problem is that QV doesn't recognize it as a correct expression as you can see :
'JerTiempo' is the name of a Hierarchical Group composed by (Year,Month), it shows that JerTiempo is not a correct FieldName, and it's true because is not a field of any table. But I think Qlikview need to add the Hierarchical Groups as well (as if they are some kind of field names).
Because developers (as me) could get a wrong conclusion and thing this is wrong and they can't do that.
A colleague of the job has recently installed the new release of QV 10, and I got noticed that it doesn't show "JerTiempo" as a bad field name or an error, but it still doesn't recognize it.
The duty of us is to improve this incredible tool.
Regards.