Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sspawar88
Creator II
Creator II

Hide Table on selection in list Box


Hi Community,

if i'm having one list box which are having seven department name.

i have created seven different table in which contain all related column of department separately.

how can i implement

--> When i click on one department name the related table should appear other should be hide.

what can i do for it in my qlikview application.?

25 Replies
sspawar88
Creator II
Creator II
Author

yes.. thats my solution.

Thanks sunny.

swuehl
MVP
MVP

I am really, really glad we got this sorted out.

Regards,

Stefan

sunny_talwar

I agree

sspawar88
Creator II
Creator II
Author

parikshit88
Contributor
Contributor

Hi , The solutions is working for only one values.

In case in the same chart if I want to show data for multiple values then how to pass Dept1, Dept2 . . . values in the getfieldselections()?

please suggest.

sunny_talwar

May be like this

=SubStringCount('|' & GetFieldSelections(Dept, '|') & '|', '|Dept1|') > 0

so, now if you select Dept1 and Dept2, Dept1 will still show up...