Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pameladg0612
New Contributor

How to disable a drill down when the values/fields are already selected in another drill down?

How to disable a drill down when the values/fields are already selected in another drill down?

5 Replies
prat1507
Valued Contributor

Re: How to disable a drill down when the values/fields are already selected in another drill down?

are you talking about listboxes?

pameladg0612
New Contributor

Re: How to disable a drill down when the values/fields are already selected in another drill down?

A dropdown

Re: How to disable a drill down when the values/fields are already selected in another drill down?

Looks like you need this?

If(GetSelectedCount(FieldName)>0, 0, 1)

pathiqvd
Contributor III

Re: How to disable a drill down when the values/fields are already selected in another drill down?

Hi,

May be like this,

If you want to disable when select in Listbox use this

create drill drown like:-

dim1:- =ID

dim2:- =if(GetSelectedCount(ID)=0 and GetSelectedCount(NAME)=0,NAME,ID)

Or as per your question create 2 drill downs, use 1 drill down in one chart and one more in next chart

Regards,

arvind_patil
Valued Contributor II

Re: How to disable a drill down when the values/fields are already selected in another drill down?

HI Pamela,

Add Condition here:

11.png:

Condition:

GetSelectedCount(_DimensionBudget) <=0 and not WildMatch(vDetails1,'5','6')

Thanks,

Arvind Patil