topic Qlikview remove ability to drill down on chart for a certain value in QlikView

Qlikview remove ability to drill down on chart for a certain value

matthewp — Tue, 15 Sep 2015 12:20:53 GMT

I have a basic bar chart that has 4 values on the X axis (`All`, `Yes`, `No` & `Deleted`) and then a `count` for the y axis.

I only want the user to be able to drill down on the `Yes`, `No` & `Deleted` bars and NOT the `All` bar.

Is this even possible?

Re: Qlikview remove ability to drill down on chart for a certain value

Anonymous — Tue, 15 Sep 2015 12:27:06 GMT

Hi Matthew that is an interesting question. Is the 'All' bar a sum of the other bars ? What do you drill down too ? Are each of these bars expressions on their own ?

Re: Qlikview remove ability to drill down on chart for a certain value

matthewp — Tue, 15 Sep 2015 12:29:07 GMT

No the all bar is just a count of statuses with the status all.

It just drills down to only showing the all bar. infact i would be happy to just disable being able to select anything on the chart

Re: Qlikview remove ability to drill down on chart for a certain value

Anonymous — Tue, 15 Sep 2015 12:34:48 GMT

Ok then you can just use set analysis in your expression like the following:-

I have made up names for your fields so the "YesNoAllField" - will be the one which contains the (`All`, `Yes`, `No` & `Deleted`) values and 'countmeasure' is the thing you are counting. Now you will see that clicking on (`All`, `Yes`, `No` & `Deleted`) will not make any selection in this chart.

=count({<YesNoAllField=>} countmeasure).

Let me know if this answers your question.

Re: Qlikview remove ability to drill down on chart for a certain value

jonas_rezende — Tue, 15 Sep 2015 12:39:14 GMT

Hi, matthewp.

See if this helps.

Try execute following steps below:

Menu Settings -> Document Propertiers;
Groups tab;
In Groups area choice Drill Down list;
Click button Edit;
In Use Fields area, choice the field desired;
Replace current field by Ex.: if(Not Match('<field>','All'),<field>);
Click Ok.

I hope this helps!

Re: Qlikview remove ability to drill down on chart for a certain value

satishkurra — Tue, 15 Sep 2015 12:39:54 GMT

This cannot be achieved. Even i got this kind of requirement previously

Refer this

Drill-down problem

Re: Qlikview remove ability to drill down on chart for a certain value

Tue, 15 Sep 2015 12:43:58 GMT

IF YesNoAllField Field having all the dimensions

If your trying to showcase Yes,no Deleted in the x axis try to add calculate dimension like this

If( YesNoAllField <>'All',YesNoAllField ) this is your dimension and expression remains as it is

Let me know if my understanding correct or not

Re: Qlikview remove ability to drill down on chart for a certain value

matthewp — Tue, 15 Sep 2015 12:44:52 GMT

Actually solved this quite easily (for disabling them all in chart)

Right click > general > tick read only.

Then limit the list selection boxes

Re: Qlikview remove ability to drill down on chart for a certain value

Anonymous — Tue, 15 Sep 2015 12:48:59 GMT

Brilliant solution - well done I have never thought of clicking that !