Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
Mark4
Partner
Partner

Footnotes in tree chart with drill down dimension

Hello Community,

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.

Any ideas?

 

Labels (1)
1 Solution

Accepted Solutions
y_grynechko
Creator III
Creator III

Hey,

=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

1 Reply
y_grynechko
Creator III
Creator III

Hey,

=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