Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

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

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?

4 Replies
MVP
MVP

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

You could consider using a cycle group.

edgar_88
Contributor

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

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.

MVP & Luminary
MVP & Luminary

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

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.

jeremybrown
New Contributor

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

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.