Dynamic Hierarchy levels

[IanCockcroft]

Hi guys,

I am replacing reports written in qlickview.

Mostly its been a breeze.

The one report uses a company hierachy and financial measures. Usng a  slider, a matrix is populated wiith the selected hierarchies.

e.g. 

if the slider selection is 1 to 5, the matrix looks

level 1

   level 2

     level 3

          level 4

             level 5   

if 5 to 9 is selected, the matrix  changes to 

level 5

   level 6

     level 7

          level 8

             level 9 

Anyone done something similar or have any idea how to do it?

I will try attach some screenshots to better explan it

thanks in advance

Ian

[dax]

Hi lanCockroft,

As I know , there is no option to achieve this goal. We can’t use measure in Slicer, and if we use column, it is hard to create relationship between hierarchies and slicer. So workaround is that you could create a measure like below

Measure 11 = if(ISINSCOPE(Table8[l1]),1,if(ISINSCOPE(Table8[l2]),2,3))

Then you could apply filter on this measure  like below

When you drill down, it will show only two level for you by click below button(but if you click expand all down one level, this won't work)

Or you also could try to use hierarchySlicer to achieve this goal. You could refer to Dynamic Level Selection in Hierarchy (Matrix view)  for details.

Best Regards,

Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.