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

[matthewp]

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?

[Anonymous]

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 ?

[matthewp]

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

[Anonymous]

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.

[jonas_rezende]

Hi, matthewp.

See if this helps.

Try execute following steps below:

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

I hope this helps!

[satishkurra]

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

Refer this

Drill-down problem

[#7]

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

[matthewp · Accepted solution]

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

Right click > general > tick read only.

Then limit the list selection boxes

[Anonymous]

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