Hello,
I am having trouble with creating a dynamic chart title in my dashboard. i have looked at numerous forums and cant seem to find one that discusses this problem. I am working with Employee data and essentially my drill down looks like this: Executive --> Function --> Sub-Function --> Business Unit --> Employee. I want my chart title to say 'Number of Employees by: _________'. I am currently using GetSelectedCount() and the dynamic title works, however in a drill down in qlik, if the layer has only one option, it skips that layer completely and goes on to the next. in this case the expression does not recognize that that layer that only had one option has been selected and therefore the chart title freezes on the layer that doesnt show up. for example, say when you drill down to sub-function, there is only one option for a sub function under that function that you have already selected. then the chart displays the next layer (that is business unit) but the chart title still says 'number of employees by: sub-function'.
Thanks!
