Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to come up with something here: One of the asks is to have multiple buttons on the top of a sheet such as "Product", "Territory", "Segment", "Campaigns", etc etc
On the bottom would be a table. The table would have one column defaulted to territory and a bunch of measures. If a user clicks on "Product", the table will automatically show the measure values but with "Product" as a dimension. If the user clicks on "Campaigns", the table will automatically show the measure values but now with "Campaign" as a dimension.
My question: Is this possible in Qlik Sense? I'm thinking I'd have to use a pivot table with all the dimensions I'm looking to use on the left but have Territory be the default value. But I'm also noticing buttons/ variable inputs aren't very straightforward based on what I'm seeing on the Qlik Community sites. Any help would be greatly appreciated.
Hi @default_the_pig,
I will suggest you to create separate tables for each button and put them in the container object, and you can show hide the tables based on the buttons by passing the values in the variable to show the appropriate table on the button click.