topic Re: Issues with Cyclic Drill down in QlikView

Issues with Cyclic Drill down

Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have issues with cyclic drilldown. Attached reference application and data file

1- Can we remove the cyclic button from header and put it in separate dropdown ?

2- In cyclic , can we drill down directly to next dimension instead of clicking the header to drill down?

Please help . urgent

Re: Issues with Cyclic Drill down

trdandamudi — Mon, 22 Aug 2016 18:36:09 GMT

1- Can we remove the cyclic button from header and put it in separate drop down ?

You can but you will not get the same view as you shown in the table.

2- In cyclic , can we drill down directly to next dimension instead of clicking the header to drill down?

Place your cursor on the drop down in the cycle button and you will see a drop down list and you can select as needed. (See pic below)

Re: Issues with Cyclic Drill down

vishsaggi — Mon, 22 Aug 2016 18:36:30 GMT

Can you explain a little what exactly you mean cyclic button in a separate dropdown ? You can use pivot table by removing your Cyclic dimension and click on + signs to drill down to County and City.

Re: Issues with Cyclic Drill down

othniel2014 — Mon, 22 Aug 2016 18:59:26 GMT

Are you using a simple table just to order it?

if you need to deploy by level, use a pivot table, if you use a simple table just to order it,

I have a method of sorting a pivot table

in the chart,

--->tab "genaral" change a Pivot Table

--->tab "dimension" ---> remove "Location" and add --->Continent, Country, City

--->tab "sort" ----> expression ---> =sum(Spend) just for expressions to sort.