Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

singhpooja
Contributor III

Hide data in list box by selecting some items from other list box in qliksense

Hi Experts,

Do we have any option in QlikSense through that we can hide data from list box.

For example I have two fields in my data set like following. So here if we are selecting A from Group Field so only IDs associated with A should appear in PartyId box.

GroupPartyId
A455674
A465
B3454
B941
C5465
C4679
A

69784651

Thanks & Regards,

Pooja

1 Solution

Accepted Solutions
omarbensalem
Esteemed Contributor

Re: Hide data in list box by selecting some items from other list box in qliksense

yes;

in your PartyId list box; change the dimension

from :

PartyId

to : (it would be better to create it as a master dimension)

aggr(only({<Group=p(Group)>}PartyId),PartyId)

4 Replies
consultant_bi
Contributor

Re: Hide data in list box by selecting some items from other list box in qliksense

Hello,
do you mean that when you choose a value of the field Group then the list box display just the rows with the same value Group ?

if it's that you need to add the graphic filter pane on your sheet and put as dimension your field Group.

omarbensalem
Esteemed Contributor

Re: Hide data in list box by selecting some items from other list box in qliksense

yes;

in your PartyId list box; change the dimension

from :

PartyId

to : (it would be better to create it as a master dimension)

aggr(only({<Group=p(Group)>}PartyId),PartyId)

omarbensalem
Esteemed Contributor

Re: Hide data in list box by selecting some items from other list box in qliksense

result: (per analogy)

Capture.PNG

singhpooja
Contributor III

Re: Hide data in list box by selecting some items from other list box in qliksense

Thanks Omar, this one has worked for me

Regards,

Pooja