Path in cyclic drill down group:urgent

[#1]

Hi,

I want to depict the path of drilldown over my report .

For eg

I have cyclic group of Continents,Countries and Cities .

-  If user click on North America and then drill to countries and then select Canada and then drill down to Cities and click to Toronto

then path should be like this

All > North America > Canada > Toronto

and this path should update as user drills into the report like first only north america, then adds canada and then adds toronto

[rupamjyotidas]

Try using this expression

=GetFieldSelections(Continent)&'->'&GetFieldSelections(Country)&'->'&GetFieldSelections(City)

[Ponkaviyarasu]

Hi Anubhav,

you can use Button object to drill down information by Setting variables in Actions

[Gysbert_Wassenaar]

If you want to drill down then change the group type from Cyclic Group to Drill-down Group.

[#5]

I want this implementation in cyclic group only

[Gysbert_Wassenaar]

Good luck then. I'm not going the create that particular monster. Perhaps you can find somebody else daft enough to try to mess about wih a cyclic group of calculated dimensions.

[vvvvvvizard]

Either use the Drill down group to drill down or uninstall Qlikview

[agomes1971]

Hi,

you should take in account the inputs given by Gysbert!

Regards

André Gomes

[MarcoWedel]

Hi,

I guess your question rather is about creating and presenting the path information than about drill-down vs. cyclic dimension groups, so possible solutions might be:

(drill down group in this case to simplify the actual drilling but without influence on the path information)

using this title expression:

or using the standard GetCurrentSelections() function:

or slightly modified:

sticking to your cyclic group instead keeps the possibility to select more than one value in the chart:

hope this helps

regards

Marco