Dimension Drill Down Group with conditional expression

[peschu123]

Hi,

is it possible to use conditional expression depending on which dimension is chosen in the drill down group?

I want to create a straight table with some Values and descriptions to an order, than I want to click on the "order no" to see all suborders... This works pretty well with the drill down group of order no,suborder no as dimension. Problem begins that field names etc. are different and I need to show different values on each dimension.

Hope its easy to understand what I mean.

Thanks in advance for your help.

[Gysbert_Wassenaar · Accepted solution]

You can use the getcurrentfield function to get the name of the active field in the group. If you're using QV11 and want to show/hide colums based on the active field you can use the conditional expression: if(getcurrentfield(GroupNameHere)='order no', 1, 0)

If you mean you want to dynamically pick a dimension to show based on the active field of the group then you can use something like:

if(getcurrentfield(GroupNameHere)='order no', DimA,

    if(getcurrentfield(GroupNameHere)='suborder no',DimB,

        if(getcurrentfield(....etc.... )))

[peschu123]

Hey Gysbert,

Great and thank you so much for your help.It works like a charm.If we ever meet you get an evening free drinks.

It works but the editor marks it as wrong, but says expression ok... This happens with set expressions sometimes too.