Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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.
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)
result: (per analogy)
Thanks Omar, this one has worked for me
Regards,
Pooja