Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
" 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
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.