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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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.