How to prevent auto drill down when there is only one option to select?
LOAD * INLINE [
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?
=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))
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
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.