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: 
Dan72
Contributor II
Contributor II

Linking objects on a sheet

Hello, I am relatively new to Qlik, but I am building an App that connects to several GSheets, and the field connections between the first two GSheets have been defined via the Data Manager and I am now starting to build my first visualisation sheet. I have created a drop-down list control based on column data in one of the GSheet tables, using a variable input object (I think this is the good approach?) , and I now want to create additional objects on the sheet that show corresponding data from the GSheets based on the selection in the drop-down menu, but I can't figure out how to ensure the link between the objects, I tried playing with using a variable to capture the drop-down selection - but how to get this to drive the content of the other objects, I think I am missing something very simple, any help would be appreciated (or point me to a relevant training). Many thanks.

Labels (1)
2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

" using a variable input object (I think this is the good approach?) "

No, that is not the typical approach. Instead use a Filter Pane to make selections in the field(s). That will automatically filter the data in your other sheet objects. 

-Rob

Dan72
Contributor II
Contributor II
Author

Hello Rob, many thanks for the reply firstly!, I am aware I can use a filter pane but they take up too much room, I am creating a "One-Page" summary of data for each Project in a Portfolio, and I just want the users to select from a small drop-down menu that is 1 row high max. with no headers (i.e. only the selected item once it has been chosen), when I use a filter pane I can reduce to 1 row high but it only displays the column header and I cannot find a way suppress the column header (and the row it occupies), but if there is a way to do this - happy to try it.