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

[Anonymous]

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.

Group	PartyId
A	455674
A	465
B	3454
B	941
C	5465
C	4679
A	69784651

Thanks & Regards,

Pooja

[consultant_bi]

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 · Accepted solution]

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]

result: (per analogy)

[Anonymous]

Thanks Omar, this one has worked for me

Regards,

Pooja