topic Re: Filters as buttons in QlikView

Filters as buttons

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Me and a colleague are trying to create buttons that filters out unwanted data.

An example of our data set is attached. So, for instance, how would I go about creating a filter on the "English Clubs" button that when pressed filters so that only those rows where "England" appears in the "Country of Club" column.

Likewise, how would I go about creating a filter on the "Barca/Real" button that only shows the rows where either "Barcelona" or "Real Madrid" appear in the "Club" column.

Thanks in advance,

Gareth

Re: Filters as buttons

oscar_ortiz — Thu, 24 Aug 2017 14:11:40 GMT

Gareth,

You can add actions to your macros as follows:

This will take care of your filters as needed.

Good luck!

Oscar

Re: Filters as buttons

Anonymous — Thu, 24 Aug 2017 14:15:35 GMT

Thanks Oscar,

That was simpler than I thought!

Cheers,

Gareth