topic Re: Path in cyclic drill down group:urgent in QlikView

Path in cyclic drill down group:urgent

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Path in cyclic drill down group:urgent

rupamjyotidas — Tue, 30 Aug 2016 13:53:48 GMT

Try using this expression

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

Re: Path in cyclic drill down group:urgent

Ponkaviyarasu — Tue, 30 Aug 2016 13:59:33 GMT

Hi Anubhav,

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

Re: Path in cyclic drill down group:urgent

Gysbert_Wassenaar — Tue, 30 Aug 2016 14:05:22 GMT

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

Re: Path in cyclic drill down group:urgent

Tue, 30 Aug 2016 14:07:14 GMT

I want this implementation in cyclic group only

Re: Path in cyclic drill down group:urgent

Gysbert_Wassenaar — Tue, 30 Aug 2016 14:18:23 GMT

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.

Re: Path in cyclic drill down group:urgent

vvvvvvizard — Tue, 30 Aug 2016 14:23:03 GMT

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

Re: Path in cyclic drill down group:urgent

agomes1971 — Tue, 30 Aug 2016 14:23:31 GMT

Hi,

you should take in account the inputs given by Gysbert!

Regards

André Gomes

Re: Path in cyclic drill down group:urgent

MarcoWedel — Wed, 31 Aug 2016 00:24:28 GMT

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