If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Is there a way to use a calculation in the footote of a tree chart showing the next selection in a dimension drill down?
For example, my master dimension drill down is:
Field 1 (fx)
Field 2 (fx)
Field 3 (fx)
If Field 1 is defaulted I would like the footnote to say: "Make a selection to view (Field 2)"
If Field 2 is selected I would like the footnote to say "Make a selection to view (Field 3)"
and so on.
I tried an if(isnull() calculation and it broke down around the third selection.
=if(GetSelectedCount([Field (1)]) < 1 ,'Make a selection to view (Field 2)',if(GetSelectedCount([Field (2)]) < 1 ,'Make a selection to view (Field 3)','No more drill downs'))
You need to add a couple more ifs to work with cases like: Field 2 is selected but Field 1 is not but I am sure you are going to figure that out.
View solution in original post