topic Re: How to prevent auto drill down when there is only one option to select? in QlikView

How to prevent auto drill down when there is only one option to select?

Fri, 20 Nov 2020 18:02:30 GMT

data:

LOAD * INLINE [

ID,CAT,ProductId,Amt

2123,Group,a,10

2445,Group,b,10

3455,Group,c,10

2345,Group,d,10

] ;

I have a drill down group created for the about data on ID,CAT and ProductId.

I have a list box created for this drill down group. When I make a selection for ID, it skips to the ProductId as there is only one selection that I can make for CAT. I know this is normal behavior. Instead of this, Can I force the list box to show options irrespective of how many values were available?

Re: How to prevent auto drill down when there is only one option to select?

swuehl — Mon, 18 Jan 2016 21:39:59 GMT

You could consider using a cycle group.

Re: How to prevent auto drill down when there is only one option to select?

Anonymous — Mon, 18 Jan 2016 23:49:27 GMT

don´t with a group.

Add a calculated dimension with this expression.

=If(GetSelectedCount(Country)<>1,

'Country',

If(GetSelectedCount(State)<>1,

'State',

'City'

)

So, if the user select in any other field, the condition is false and don´t change.

Re: How to prevent auto drill down when there is only one option to select?

jagan — Tue, 19 Jan 2016 01:07:17 GMT

Hi,

Try like this

Calculated Dimension:

=If(GetSelectedCount(ID) = 0 AND GetSelectedCount(CAT) = 0 AND GetSelectedCount(ProductId) = 0, ID,

If(GetSelectedCount(ID) > 0 AND GetSelectedCount(CAT) = 0 AND GetSelectedCount(ProductId) = 0, CAT, ProductId))

Expression:

=Sum(Amt)

Provide filters for ID, CAT and ProductId, if users selects values from filters it works as expected, if users click on the bars then it will not work as expected. This is the default behavior of Qlikview, so you can make the chart as Read Only to restrict the clicking on Bars by using

Chart Properties -> General -> Read Only

Please find attached file for solution.

Regards,

Jagan.

Re: How to prevent auto drill down when there is only one option to select?

Anonymous — Sun, 21 Oct 2018 16:21:01 GMT

Honestly, it is so annoying that we have to come up with workarounds so auto drill in doesn't occur. The biggest aggravation of QlikSense is how much time it takes for tiny adjustments to the visualizations. Do they expect companies to spend 10s of thousands of dollars of salary and QA time so something doesn't auto drill in?!?!?! How ridiculous. And the formula does work is such a basic example, but when you have to choose between aggregations and there are different children among parents, then you have to come up with something more advanced.